Versions Compared

Old Version 21

changes.mady.by.user Tony Johnson

Saved on

compared with

New Version Current

changes.mady.by.user Tony Johnson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

Area

Problem

Comments

Resolution

Tomcat

Web applications were all down

tomcat01 had run out of permgen space

GG-23@JIRA


10:00am (Daniel Flath):

Wiki MarkupThe new stored procedures (See April 21 note) came with new queries.    Until Oracle has run the new queries long enough to gather execution-plan statistics, it cannot recommend a more efficient execution-plan.    Two of the queries that are most heavily executed during dependency evaluation were identified by the \ [Grid Control\] top SQL activity report.    Oracle is recommending execution-plan improvements for both.    The revised plan estimates indicate that we may benefit significantly by implementing the changes.

 I have implemented the explain plans, shown here, and Warren will submit another run to L1 to see if the changes made a difference, and then iterate over this process again if there are further recommendations from Oracle.


...