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.

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

When we perform an ORTA, we classify all IO time as queue time subclassification. This may seem like an unfortunate and desperate abstraction, but it actually fits perfectly from a database perspective. If no IO occurs, Oracle satisfies all requests consuming only CPU time. But as the workload increases and some of this work requires IO, response time begins to increase; that is, queue time begins to increase; that is, IO time begins to increase. The pattern fits very nicely into an ORTA.

In summary, both our CPU service time and IO queue time abstractions fit very nicely into an ORTA, providing us with the opportunity to apply predictive mathematics to evaluate alternative firefighting solutions.

The classic response-time curve in Figure 9-8 highlights the differences between CPU and IO subsystems. It turns out that real Oracle systems operate somewhere between the two. The dotted line in Figure 9-8 represents an Oracle system that operates completely and only with CPU. In others words, there is no physical IO, only logical IO activity. In contrast, the solid line represents an IO-centric Oracle system. No Oracle system can operate with only IO, because there must be CPU resources consumed to run processes, which includes processing the IO once it has been read from disk.

©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!