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@xxxxxxxxxx] ;
Sent: Friday, April 29, 2016 2:24 PM
To: andrew.kerber@xxxxxxxxx; 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@xxxxxxxxx>
Datum: 29.04.2016 20:53 (GMT+01:00)
An: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
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.'
