Database metrics measure in AWR_awr报告中metric before单位是什么-优快云博客

本文链接：https://blog.youkuaiyun.com/dbaheng/article/details/16917963

这篇博客探讨了Oracle数据库自动工作负载 repositories (AWR) 报告中关于metric统计的部分，特别是从v$sysmetric视图获取的数据。内容包括Buffer Cache Hit Ratio、Memory Sorts Ratio、Redo Allocation Hit Ratio等关键指标的解释，以及这些指标如何反映数据库性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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