| 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: tkprof and Statspack
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_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Saturday, March 27, 2004 7:13 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: tkprof and Statspack
Deep - Just try Google. Both are very unique words.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Arghadeep Chatterjee
Sent: Saturday, March 27, 2004 12:55 AM
To: oracle-l_at_freelists.org
Subject: tkprof and Statspack
Hi All,
Can you guys plz send me some links on tkprof and statspack other than
Oracle
Doc.
Thanks
Deep
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
 |
 |