Oracle Scratchpad

September 10, 2009

Philosophy – 5

Filed under: Philosophy,Statspack,Troubleshooting — Jonathan Lewis @ 6:31 pm GMT Sep 10,2009

Trouble-shooting with Statspack / AWR:

Something has to be top of the “Top 5 Timed Waits” … even when there are no performance problems.

[The Philosophy Series]
[Further Reading on Statspack]


  1. I like the mantra “If no one is complaining, there are no performance problems”…….

    Comment by Craig T — September 10, 2009 @ 7:30 pm GMT Sep 10,2009 | Reply

  2. Said by me when the system I had been setting up went into production: “The system ran fine without anyone on it!”

    Comment by Gary E — September 10, 2009 @ 8:08 pm GMT Sep 10,2009 | Reply

  3. When your own scripts for checking performance are the most demanding statements in the system, either your job is done or you need to tune your own scripts :-)

    (sheepishly once guilty of the second situation)

    Comment by randolfpant — September 10, 2009 @ 9:49 pm GMT Sep 10,2009 | Reply

  4. I’ve found Foglight monitoring SQL at the top of the pile before – so wind down the sampling from every couple of secs to every 30 minutes

    Comment by Nigel Thomas — September 11, 2009 @ 10:21 am GMT Sep 11,2009 | Reply

  5. …and if you do not recognise this, you will develop Compulsive Tuning Disorder!

    Comment by David Kurtz — September 11, 2009 @ 11:39 am GMT Sep 11,2009 | Reply

  6. If no one is complaining, either the lead pipe is working or the phone is down.

    Comment by joel garry — September 11, 2009 @ 10:05 pm GMT Sep 11,2009 | Reply

  7. Don’t get me started on how much time I wasted explaining to a local “expert” that redo log write waits of less than 1ms in 99% of the cases is NOT a performance problem…

    Comment by Noons — October 10, 2010 @ 9:20 pm GMT Oct 10,2010 | Reply

  8. Something has to be top of the “Top 5 Timed Foreground Events” (11gR2 AWR)

    Comment by Jayant — January 12, 2012 @ 11:13 pm GMT Jan 12,2012 | Reply

RSS feed for comments on this post.

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by