RE: statspack and OS stats
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 21:50:19 -0500
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David
Sent: Wednesday, June 23, 2004 4:05 PM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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:
