来自农村的老实娃
分类: Oracle
2010-12-01 09:40:02
V$SYSMETRIC
displays the system metric values captured for the most current time interval for both the long duration (60-second) and short duration (15-second) system metrics.
Column | Datatype | Description |
---|---|---|
BEGIN_TIME |
DATE |
Begin time of the interval |
END_TIME |
DATE |
End time of the interval |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
GROUP_ID |
NUMBER |
Metric group ID |
METRIC_ID |
NUMBER |
Metric ID |
METRIC_NAME |
VARCHAR2(64) |
Metric name |
VALUE |
NUMBER |
Metric value |
METRIC_UNIT |
VARCHAR2(64) |
Metric unit description |
V$SYSMETRIC_HISTORY
displays all system metric values available in the database. Both long duration (60-second with 1 hour history) and short duration (15-second with one-interval only) metrics are displayed by this view.
Column | Datatype | Description |
---|---|---|
BEGIN_TIME |
DATE |
Begin time of the interval |
END_TIME |
DATE |
End time of the interval |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
GROUP_ID |
NUMBER |
Metric group ID |
METRIC_ID |
NUMBER |
Metric ID |
METRIC_NAME |
VARCHAR2(64) |
Metric name |
VALUE |
NUMBER |
Metric value |
METRIC_UNIT |
VARCHAR2(64) |
Metric unit description |
V$SYSMETRIC_SUMMARY
displays a summary of all system Metric values for the long-duration system metrics. The average, maximum value, minimum value, and the value of one standard deviation for the last hour are displayed for each metric item.
Column | Datatype | Description |
---|---|---|
BEGIN_TIME |
DATE |
Begin time of the interval |
END_TIME |
DATE |
End time of the interval |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
GROUP_ID |
NUMBER |
Metric group ID |
METRIC_ID |
NUMBER |
Metric ID |
METRIC_NAME |
VARCHAR2(64) |
Metric name |
NUM_INTERVAL |
NUMBER |
Number of intervals observed |
MAXVAL |
NUMBER |
Maximum value observed |
MINVAL |
NUMBER |
Minimum value observed |
AVERAGE |
NUMBER |
Average value over the period |
STANDARD_DEVIATION |
NUMBER |
One standard deviation |
METRIC_UNIT |
VARCHAR2(64) |
Metric unit description |
v$sysstat
STATISTIC#: 标识
NAME: 统计项名称
VALUE: 资源使用量
该视图还有一列class-统计类别但极少会被使用,各类信息如下:
1 代表事例活动
2 代表Redo buffer活动
4 代表锁
8 代表数据缓冲活动
16 代表OS活动
32 代表并行活动
64 代表表访问
128 代表调试信息
注意:Statistic#的值在不同版本中各不相同,使用时要用Name做为查询条件而不要以statistic#的值做为条件