RE: statspack and OS stats

From: Chris Stephens <ChrisStephens_at_Affina.com>
Date: Wed, 23 Jun 2004 21:19:50 -0500
Message-ID: <E07BCCA62696AB40BE1267A7419A281A2B51A5@apollo.affina.net>

Oh yeah...grid control offers a lot of os information off the shelf as well.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Kanagaraj Sent: Wednesday, June 23, 2004 6:29 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: statspack and OS stats

David,

>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=20
>info in any
>manuals or white papers, etc anyone has come across?

In the case mentioned, STATSPACK is not leveraged. The PERFSTAT schema, however, is used to contain the tables where OS stats may be loaded. UNIX
Ksh Scripts collect and load this information... I believe Craig Shallahammer (OraPub.com) has some scripts/notes on this.

>Also, I would like to create a database that functions as a central
>statspack repository that houses all of the statspack=20
>information for all
>databases in the enterprise. That db could then be used as a central
>reporting repo for statspack information.

A simple export/import or CTAS over Dblinks of Statspack data to a central
repository may well do this job.=20

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!=20

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

  ---

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 Wed Jun 23 2004 - 21:16:34 CDT