RE: 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?

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.