DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_SYSMETRIC_SUMMARY

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","BEGIN_TIME","END_TIME","INTSIZE","GROUP_ID","METRIC_ID","METRIC_NAME","METRIC_UNIT","NUM_INTERVAL","MINVAL","MAXVAL","AVERAGE","STANDARD_DEVIATION","SUM_SQUARES","CON_DBID","CON_ID" from INT$DBA_HIST_SYSMETRIC_SUMMARY
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "BEGIN_TIME"
, "END_TIME"
, "INTSIZE"
, "GROUP_ID"
, "METRIC_ID"
, "METRIC_NAME"
, "METRIC_UNIT"
, "NUM_INTERVAL"
, "MINVAL"
, "MAXVAL"
, "AVERAGE"
, "STANDARD_DEVIATION"
, "SUM_SQUARES"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_SYSMETRIC_SUMMARY