Oracle教程

Oracle 视图 DBA_HIST_RSRC_METRIC 官方解释，作用，如何使用详细说明

本站中文解释

_HISTORY

DBA_HIST_RSRC_METRIC_HISTORY 是一个视图，用于查询 Oracle 11g 以上版本的资源管理历史信息。该视图提供了一种查看系统资源管理器(SRM)参数设置和监控资源使用趋势的有效方法。字段定义和用法如下 ：

BEGIN_INTERVAL_TIME – 记录开始时间，这会与其他相关视图对应。

END_INTERVAL_TIME – 记录结束时间，且与其他相关视图对应。

RESOURCE_NAME – SRM资源名称。

METRIC_NAME – 测量名称。

CURRENT_VALUE – 监控指定时间段内的度量值。

TREND – 表示度量值是上升还是下降。

USAGE – 用于确定读取/写入等操作的度量值。

使用DBA_HIST_RSRC_METRIC_HISTORY视图的方法如下：

1.查询最后一小时或者改变的所有SRM度量值。

使用以下示例查询：

SELECT RESOURCE_NAME, METRIC_NAME, CURRENT_VALUE, TREND, USAGE
FROM DBA_HIST_RSRC_METRIC_HISTORY
WHERE BEGIN_INTERVAL_TIME > SYSDATE -1/24
and END_INTERVAL_TIME = TO_TIMESTAMP(‘2019-04-01′,’YYYY-MM-DD’)
AND END_INTERVAL_TIME

官方英文解释

DBA_HIST_RSRC_METRIC displays information about historical Resource Manager metrics for the past hour.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database ID for the snapshot

INSTANCE_NUMBER

NUMBER

NOT NULL

Instance number for the snapshot

BEGIN_TIME

TIMESTAMP(3)

NOT NULL

Begin time of the interval

END_TIME

TIMESTAMP(3)

NOT NULL

End time of the interval

INTSIZE_CSEC

NUMBER

NOT NULL

Interval size (in hundredths of a second)

SEQUENCE#

NUMBER

NOT NULL

A sequential counter that uniquely describes the V$RSRC_PLAN_HISTORY entry to which these consumer group statistics apply. When the instance is restarted, this value is reset to zero.

CONSUMER_GROUP_ID

NUMBER

NOT NULL

Consumer group object ID (a unique number, consistent across database shutdowns and startups)

CPU_CONSUMED_TIME

NUMBER

NOT NULL

Cumulative amount of CPU time consumed by all sessions in the consumer group, in milliseconds

CPU_WAIT_TIME

NUMBER

NOT NULL

Cumulative amount of time that sessions waited for CPU because of resource management, in milliseconds. This does not include waits due to latch or enqueue contention, I/O waits, and so on. When CPU resources are not being actively managed, this value is set to zero.

AVG_RUNNING_SESSIONS

NUMBER

Average number of sessions in the consumer group that are currently running

AVG_WAITING_SESSIONS

NUMBER

Average number of sessions in the consumer group that are waiting for CPU due to resource management. When CPU resources are not being actively managed, this value is set to zero.

RUNNING_SESSION_LIMIT

NUMBER

  

Maximum number of sessions in the consumer group that can run simultaneously. The value of this column is NUM_CPUS multiplied by the consumer group’s MAX_UTILIZATION_LIMIT directive in the current Resource Manager plan.

AVG_CPU_UTILIZATION

NUMBER

Average percentage CPU consumed by the consumer group

IO_REQUESTS

NUMBER

NOT NULL

I/O requests

IO_MEGABYTES

NUMBER

NOT NULL

I/O megabytes

IOPS

NUMBER

I/O operations per second during the previous minute for this PDB

IOMBPS

NUMBER

I/O megabytes per second during the previous minute for this PDB

AVG_ACTIVE_PARALLEL_STMTS

NUMBER

The average number of parallel statements that were running during the 1-minute metric window

AVG_QUEUED_PARALLEL_STMTS

NUMBER

The average number of parallel statements that were queued during the 1-minute metric window

AVG_ACTIVE_PARALLEL_SERVERS

NUMBER

The average number of parallel servers that were actively running as part of a parallel statement during the 1-minute metric window

AVG_QUEUED_PARALLEL_SERVERS

NUMBER

The average number of parallel servers that were requested by queued parallel statements during the 1-minute metric window

CON_DBID

NUMBER

The database ID of the PDB for the sampled session

CON_ID

NUMBER

The ID of the container that CON_DBID identifies. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 DBA_HIST_RSRC_METRIC 官方解释，作用，如何使用详细说明
分享到：

相关推荐