DBA_HIST_SYSMETRIC_SUMMARY


https://sites.google.com/site/oraclemonitor/long-duration-sysmetric
https://sites.google.com/site/oraclemonitor/short-duration-sysmetric

 (run on 11g - see http://www.juliandyke.com/Internals/Oracle11_1/Metrics.html )
 ( see statistics definitions on https://sites.google.com/site/oraclemonitor/oracle-statistics-defined-11-2 )

 diff of 10.2 vs 11.1 vs 11.2


DBA_HIST_SYSMETRIC_SUMMARY

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 BEGIN_TIME                                NOT NULL DATE
 END_TIME                                  NOT NULL DATE
 INTSIZE                                   NOT NULL NUMBER
 GROUP_ID                                  NOT NULL NUMBER
 METRIC_ID                                 NOT NULL NUMBER
 METRIC_NAME                               NOT NULL VARCHAR2(64)
 METRIC_UNIT                               NOT NULL VARCHAR2(64)
 NUM_INTERVAL                              NOT NULL NUMBER
 MINVAL                                    NOT NULL NUMBER
 MAXVAL                                    NOT NULL NUMBER
 AVERAGE                                   NOT NULL NUMBER
 STANDARD_DEVIATION                        NOT NULL NUMBER
 SUM_SQUARES                                        NUMBER


total bytes read per sec
select   dbid, to_char( begin_time ,'YYYY/MM/DD HH24:MI'),
         round(average)
from     dba_hist_sysmetric_summary
where    metric_name= 'Physical Read Total Bytes Per Sec' /* and DBID=[dbid if share repository] */
order by begin_time;


select   dbid, to_char( begin_time ,'YYYY/MM/DD HH24:MI'),
         round(average)
from     dba_hist_sysmetric_summary
where    metric_name= 'Redo Generated Per Sec' /* and DBID=[dbid if share repository] */
order by begin_time;



Redo Generated Per Sec
Redo Writes Per Sec

Comments