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.

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

You can be sure you are running a blue line query if you have a defined beginning and end. You will also notice the values are very dynamic in range, whereas red line values tend to be very static, with little variance.

You're probably wondering if your existing tools and products are reporting the blue line or the red line. The only way to tell for sure is to look at the SQL they are running. The next best thing is to see if there is a defined beginning and ending point. If this is not possible, there is a good chance the tool or product is producing red line statistics. An update button may make no difference. The update button could just keep moving the red line's end point while always using the instance start time as the beginning value.

In summary, when running SQL scripts, be aware of the data used to derive the statistic. It may be less useful than you thought.

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