Database metrics measure in AWR

      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 Ratio
Redo Allocation Hit Ratio
User Transaction Per Sec
Physical Reads Per Sec
Physical Reads Per Txn
Physical Writes Per Sec
Physical Writes Per Txn