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.

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

Figure 1-3. Graph of the classic response time curve. This example shows at an arrival rate (the workload) of 1.55 transactions per millisecond (trx/ms). The response time is 3 ms/trx, the service time is 2 ms/trx, and the queue time is 1 ms/trx.

While at a university, I had a job answering the computer operations room telephone. The phone could handle multiple lines, and since I could talk with only one person at a time, sometimes I had to put someone on hold. When things were calm and someone called, I would listen to the request and handle the call, hang up, and then wait for the next call. That's when the job was relaxing. However, if the call arrival rate increased enough, someone would call while I was already talking to someone on the other line. As a result, someone had to wait his turn, or in forecasting terms, queued. I noticed once the rate of calls caused people to queue, it took only a slight increase in the call arrival rate before there were many people in the queue and they were waiting a long time. It was like everything was calm, and then-wham!-everyone was queuing.

You might have experienced this yourself with your computer systems. Performance is fine, yet the system is really busy. Then for any number of reasons, the system activity increases just a little, and-wham!-performance takes a dive. And you sit back and say, "What just happened? Everything was going fine, and the workload didn't increase that much."

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