| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack Report
A man with one foot in a bucket of ice and the other foot in boiling water
is, on average, quite comfortable. (About like a nice warm hot tub.)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Monday, July 26, 2004 11:35 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Statspack Report
Kevin
The two sources I'm aware of, aside from the Oracle documentation, are the series of Oracle Magazine articles and Don Burleson's book Oracle9i High-Performance Tuning with STATSPACK.
Also, be aware of the limitation of STATSPACK. Statistics are aggregated in two dimensions - by time (the interval you take snapshots) and by all processes on the system. Cary Millsap does a great job of pointing out the limitations of methods that perform these aggregations. My personal analogy is: "You can drown in a river that is only an average of three feet deep".
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kevin Lange
Sent: Monday, July 26, 2004 10:10 AM
To: 'oracle-l_at_freelists.org'
Subject: Statspack Report
Evening;
Does there happen to be any 'definitive' set of documentation on
interpreting the reports given out by Statspack ?
I just set it up for the first time and could use any 'direction' on what is the best documentation set for it.
Thanks
Kevin
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |