What do you do when waits don't seem to show anything?

From DB Optimizer
Jump to: navigation, search

Waits work for identifying 99% of the performance issues, but there are a few cases where waits don't work.

Waits don't measure log on time so it's important to know the statistics logons per second. When processing rollback, if it doesn't involve IO, it will simply show up as CPU time. Be sure and monitor the statistics "consistent changes".

Here is an article by James Morle on a case where waits didn't work http://jamesmorle.wordpress.com/2009/11/09/the-oracle-wait-interface-is-useless-sometimes-pt/

And the other side of the coin from Tanel http://blog.tanelpoder.com/2007/06/18/advanced-oracle-troubleshooting-guide-when-the-wait-interface-is-not-enough-part-1/