they are all pretty much the same and will have the same columns, see below
for STATS$ and the counterpart AWR, WRH views/table
---------------------------------------------------
STATS$, AWR, WRH
---------------------------------------------------
STATSPACK TABLE DBA_HIST view WRH$TABLE
--------------------------------------------------------------------------------------------------
stats$snapshot dba_hist_snapshot WRM$_SNAPSHOT
stats$parameter dba_hist_parameter WRM$_SNAPSHOT, WRH$_PARAMETER,
WRH$_PARAMETER_NAME
stats$sql_summary dba_hist_sql_summary WRM$_SNAPSHOT, WRH$_SQL_SUMMARY
stats$sysstat dba_hist_sysstat WRM$_SNAPSHOT, WRH$_SYSSTAT,
DBA_HIST_STAT_NAME
stats$system_event dba_hist_system_event WRM$_SNAPSHOT, WRH$_SYSTEM_EVENT,
DBA_HIST_EVENT_NAME
stats$filestatxs dba_hist_filestatxs WRM$_SNAPSHOT, WRH$_FILESTATXS,
DBA_HIST_DATAFILE
stats$tempstatxs dba_hist_tempstatxs WRM$_SNAPSHOT, WRH$_TEMPSTATXS,
DBA_HIST_TEMPFILE
it's been a long since I've played with statspack views. the major
difference was the the begin and end interval times are based on timestamp
data type while statspack is date
also check this script for some ideas on how to query the underlying views
https://github.com/carlos-sierra/esp_collect/blob/master/sql/esp_collect_requirements_statspack.sql
-Karl
On Fri, Apr 29, 2016 at 2:53 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
wrote:
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.'
