Oracle Scratchpad

September 10, 2009

Philosophy – 5

Filed under: Philosophy,Statspack,Troubleshooting — Jonathan Lewis @ 6:31 pm BST 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]

10 Comments »

  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 BST 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 BST 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 BST 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 BST 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 BST 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 BST 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 BST 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 BST Jan 12,2012 | Reply


RSS feed for comments on this post.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Theme: Rubric. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,267 other followers