RE: tkprof and Statspack

  • From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 28 Mar 2004 08:07:29 -0600

Deep
   My apologies for the terse reply yesterday. I was just leaving my home
and wasn't sure if anyone else would post a weekend reply to your question. 
   For STATSPACK, the major online resource that I am aware of is a series
of 3 articles that appeared in Oracle Magazine last year. Here is a link to
the second in the series:
http://otn.oracle.com/oramag/oracle/03-mar/o23expert.html
If you are studying Oracle tuning, you should be aware of the limitations of
both of these tools. STATSPACK uses overall system statistics. In his book
Optimizing Oracle Performance, Cary Millsap does a good job of explaining
the dangers of drawing conclusions from summarized information. You can read
chapter 1 of the book at:
http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf
   TKPROF summarizes Oracle trace files. Cary's book advocates Oracle trace
files as the best way to analyze Oracle performance problems. If you search
Google for Oracle 10046 you will see how to generate more detailed traces.
Cary's book is the most thorough resource for learning how to read and
interpret raw trace files. But first I would recommend going to his web site
www.hotsos.com and reviewing the free material.
   I hope this posting doesn't sound too biased, but there are many, many
experts offering tuning advice. This has been confusing to me, a mere
practicing DBA. Much of this advice was developed before Oracle started
including detailed information in trace files. The general consensus of
people a lot more expert than I am is that Cary is the current leader in
Oracle tuning theory and practice.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
Sent: Saturday, March 27, 2004 7:13 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: tkprof and Statspack


Deep - Just try Google. Both are very unique words.



Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Arghadeep Chatterjee
Sent: Saturday, March 27, 2004 12:55 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: tkprof and Statspack


Hi All,
Can you guys plz send me some links on tkprof and statspack other than
Oracle 
Doc.
Thanks
Deep

----------------------------------------------------------------
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: