AWR中的metric统计源于以下相关视图。
1、v$sysmetric维护的系统度量:(显示最近1分钟测量到数据库服务的度量值)
SQL> select * from v$sysmetric where rownum<10;
BEGIN_TIME END_TIME INTSIZE_CSEC GROUP_ID METRIC_ID METRIC_NAME VALUE METRIC_UNIT
------------------- ------------------- ------------ ---------- ---------- ------------------------------ ---------- ------------------------------
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2000 Buffer Cache Hit Ratio 98.9648683 % (LogRead - PhyRead)/LogRead
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2001 Memory Sorts Ratio 100 % MemSort/(MemSort + DiskSort)
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2002 Redo Allocation Hit Ratio 100 % (#Redo - RedoSpaceReq)/#Redo
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2003 User Transaction Per Sec 0 Transactions Per Second
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2004 Physical Reads Per Sec .548081714 Reads Per Second
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2005 Physical Reads Per Txn 33 Reads Per Txn
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2006 Physical Writes Per Sec 0 Writes Per Second
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2007 Physical Writes Per Txn 0 Writes Per Txn
24-11-2013 03:58:36 24-11-2013 03:59:37 6021 2 2008 Physical Reads Direct Per Sec 0 Reads Per Second
v$sysmetric视图包含的metrics
Buffer Cache Hit Ratio
Memory Sorts RatioRedo Allocation Hit Ratio
User Transaction Per Sec
Physical Reads Per Sec
Physical Reads Per Txn
Physical Writes Per Sec
Physical Writes Per Txn