Re: Statspack Data Definition
Date: Fri, 29 Apr 2016 23:24:48 -0400
Message-ID: <CACNsJnfkHuPX329dHgtyaDqtMjgyx7SVKpk8VBXmTGLgK0d+uw_at_mail.gmail.com>
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_at_gmail.com> 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.'
>
-- Karl Arao Blog: karlarao.wordpress.com Wiki: karlarao.tiddlyspot.com Twitter: _at_karlarao <http://twitter.com/karlarao> -- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 30 2016 - 05:24:48 CEST