Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack Report

RE: Statspack Report

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 26 Jul 2004 12:18:15 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKOEIIFBAA.mwf@rsiz.com>


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



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Jul 26 2004 - 11:17:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US