Oracle Performance Firefighting
by Craig Shallahamer

Get the book here



Craig Shallahamer's Blog

You were brought to this page based on an internet search and as a free service to Oracle DBAs.

The text below is an except from the book, Oracle Performance Firefighting, written by Craig Shallahamer of OraPub, Inc. Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click here.


©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for their familes, we ask you to respect the copyright both in intent and deed. Thank you.

-------------------------------

Based on Figure 9-3, the total service time is 16,881.6 seconds, or 16,881,600 milliseconds. Determine the service time by dividing the total service time by the unit of work value. Here is the service time math:

Determine the queue time by dividing the total queue time by the unit of work value. For Oracle systems, the total queue is all the non-idle wait time that occurred during the sample interval. Most Statspack and AWR reports have a Top 5 Timed Events section near the top of their reports. This is simply the top four most time-consuming wait events and also the CPU time. Usually the top four wait events account for 90% or more of all the non-idle wait time. For our required level of precision, we can simply sum the wait time for the top four wait events. While the details are not shown, their combined wait time is 45,672 seconds during the sample interval. Here is the queue time math:

For CPU subsystems, you can compare the actual CPU utilization (perhaps gathered from v$osstat or vmstat) with the classic utilization formula. If you picked a good unit of work, the difference should be within 15%. If the bottleneck is the IO subsystem, because of caching and batching, utilization comparison may be interesting, but it is unlikely to closely match or provide much value.

©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for their familes, we ask you to respect the copyright both in intent and deed. Thank you.


Know what's important before it's too late!

OraPub's
Performance Training

is like no other...





More Class Pics...
Get student testimonials!