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.
-------------------------------
4 If you really want to learn about Oracle internals, especially the internals that practical performance analysts don't care about, then become an Oracle kernel developer. But if you want to learn about internals that actually affect a DBAs work, you may be surprised to find a lot of useful information by reading Oracle patents. Yes, that is correct; patents. Now, I realize this is a little strange. But that's how I find out about how Oracle works without getting my hands on illegal proprietary information. Go to http://patft.uspto.gov/netahtml/PTO/search-bool.html and do a search with the assignee as Oracle. That will get you started! Patent information is publically available and free. Keep in mind that just because Oracle has a patent does not mean it must implement the invention in its kernel code.
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.
©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.
|