| 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 and OS stats
David
If you are considering digging into STATSPACK to this depth, please consider buying Don Burleson's book. He has a wealth of ideas, scripts, etc. Consider how much of your time you'll spend creating what he already provides.
Each STATSPACK table has DBID and Instance_number columns, so it is designed for the kind of centralized repository you are contemplating.
As far as free papers, Oracle Magazine published a series of articles on STATSPACK. You can find them by Googling "oramag statspack". Here is a pointer to one of them.
http://otn.oracle.com/oramag/oracle/03-jan/o13expert.html
Just bear in mind that STATSPACK aggregates performance data in two
dimensions -- across time (across the snapshot interval) and across all
sessions. It can give you an idea of your overall system behavior, but it is
much better to do like Cary Millsap suggests -- get out of your cubicle and
talk to users about their performance issues.
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 David
Sent: Wednesday, June 23, 2004 4:05 PM
To: oracle-l_at_freelists.org
Subject: statspack and OS stats
Aside from the book on statspack that is available, is there any free information available out there in regards to leveraging statspack to gether OS statistics using vmstat, iostat and the like. Any info in any manuals or white papers, etc anyone has come across?
Also, I would like to create a database that functions as a central statspack repository that houses all of the statspack information for all databases in the enterprise. That db could then be used as a central reporting repo for statspack information.
Any info or advice on these two points is appreciated. Mucho thanks in
advance...
Cheers
- David
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
 |
 |