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.
PleaseOut 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.
PleaseOut 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.
|