RE: Statspack Data Definition

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 29 Apr 2016 15:15:51 -0500
Message-ID: <5ef901d1a253$ed70c130$c8524390$_at_gmail.com>

That I know, and I also know how to generate reports. I want to get information similar to what is on the dba_hist_sysmetric_summary, but in order to do that I need column definitions and units. And also which data is cumulative which is total since the last snapshot.  

From: l.flatz [mailto:l.flatz_at_bluewin.ch] Sent: Friday, April 29, 2016 2:24 PM
To: andrew.kerber_at_gmail.com; ORACLE-L Subject: AW: Statspack Data Definition  

Btw. the scripts to create the stats pack tables are starting with sp and you find them in the rdbms/administration directory. The one that creates the statespack schema is spcreate.        

Von meinem Samsung Gerät gesendet.

• Ursprüngliche Nachricht -------- Von: Andrew Kerber <andrew.kerber_at_gmail.com> Datum: 29.04.2016 20:53 (GMT+01:00) An: ORACLE-L <oracle-l_at_freelists.org> Betreff: Statspack Data Definition

I am looking for the table and column definitions for the statspack tables in 11g. I have a customer that is on standard edition,and we need to pull some performance information. I know I have seen a document with the statspack table and column names and definitions, but evidently my google skills are deteriorating as I am unable to find it at the moment.

-- 

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'



--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 29 2016 - 22:15:51 CEST