RE: statspack and OS stats

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Wed, 23 Jun 2004 16:29:13 -0700
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC18015A3762@ussccem13.corp.hds.com>

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

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

Disappointment is inevitable, but Discouragement is optional!

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

Received on Wed Jun 23 2004 - 18:26:06 CDT