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.

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

5 This script is available today for free in the OSM tool kit. The version used in this consulting engagement watched a session based on its session identifier and serial number. The script has since been renamed to rtsess8.sql, and the current rtsess.sql script is based on the session(s) client identifier. I will talk more about the client identifier in the DBMS_MONITOR section later in this chapter.

6 If you see the word solution in an IT product, multiply the typical firefighting product cost times a million dollars. If you see the word infrastructure, do the same thing. If you see both, run far and run fast.

7 OraPub's Oracle performance view-based session level response time analysis (profiling) report is rtsess.sql. The instance-level response-time analysis (profiling) report is rtsysx.sql.

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