度量值(v$metricname v$metric)
数据库引擎计算出一个度量值,而这个值对于监控特别有用,这些值在v$metricname视图中列出。
--包含IO的度量值
SYS@PROD1> select metric_name from v$metricname where metric_name like '%IO%';
METRIC_NAME
----------------------------------------------------------------
Cell Physical IO Interconnect Bytes
Physical Write IO Requests Per Sec
Physical Read IO Requests Per Sec
Physical Write Total IO Requests Per Sec
Physical Read Total IO Requests Per Sec
Cell Physical IO Interconnect Bytes
Percentage of replay threads doing IO
WRC average IO latency
File IO Wait Time Per User Request
File IO Service Time Per User Request
10 rows selected.
SYS@PROD1> select metric_id, metric_unit, group_id, group_name from v$metricname where metric_name='Host CPU Usage Per Sec';
METRIC_ID METRIC_UNIT GROUP_ID
---------- ----------------------------------------------