RE: Statspack Report
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 10:35:22 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kevin Lange
Sent: Monday, July 26, 2004 10:10 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
