Oracle 视图 V$RSRCMGRMETRIC 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$RSRCMGRMETRIC是Oracle资源管理器视图，它可以显示Oracle数据库中正在运行的用户会话的资源使用情况，如CPU、磁盘和网络使用量等。此外，可以根据此视图区分运行状况，用来查看哪些会话正在获得最高的资源利用率，并向最重要的会话以及正在进行的操作，提供最大的性能支持。
要使用该视图，用户首先需要授予资源管理器使用V$RSRCMGRMETRIC视图的权限，然后在数据库服务器级别启用资源管理器服务选项，以便能够获得资源管理器视图提供的信息。随后，可以使用SELECT语句来从V$RSRCMGRMETRIC中检索会话的资源使用情况。
例如，要检查会话编号为4321的CPU使用情况，可以使用以下SELECT语句：
SELECT SESSION_ID,CPU_USAGE
FROM V$RSRCMGRMETRIC
WHERE SESSION_ID= 4321;
官方英文解释
V$RSRCMGRMETRIC displays information about resources consumed and wait times per consumer group.
When the STATISTICS_LEVEL is set to TYPICAL or ALL, this view contains information about CPU utilization and wait times even when no Resource Manager plan is set or when the Resource Manager plan does not monitor CPU or session resources. Metrics are collected and stored every minute when CPU utilization is not being monitored.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Begin time of the interval |
|
|
|
End time of the interval |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
A sequential counter that uniquely describes the |
|
|
|
Consumer group object ID (a unique number, consistent across database shutdowns and startups) |
|
|
|
Name of the consumer group |
|
|
|
Cumulative amount of CPU time consumed by all sessions in the consumer group, in milliseconds |
|
|
|
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. |
|
|
|
Number of CPUs that the Resource Manager is utilizing. If instance caging is enabled, then this column is equal to the value of the |
|
|
|
Maximum number of sessions in the consumer group that can run simultaneously. The value of this column is |
|
|
|
Average number of sessions in the consumer group that are currently running |
|
|
|
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. |
|
|
|
Maximum percentage of CPU that the consumer group can use at any time, with respect to the total number of CPUs in the system. The value of this column is |
|
|
|
Average percentage of CPU consumed by the consumer group, with respect to the total number of CPUs in the system |
|
|
|
Percentage of CPU decisions for which the consumer group was present. When CPU resources are not being actively managed, this value is set to zero. This column is deprecated. |
|
|
|
Percentage of the CPU decisions for which the consumer group was present and was the only consumer group present. When CPU resources are not being actively managed, this value is set to zero. This column is deprecated. |
|
|
|
Percentage of the CPU decisions that the consumer group won. When CPU resources are not being actively managed, this value is set to zero. This column is deprecated. |
|
|
|
I/O requests |
|
|
|
I/O megabytes |
|
|
|
The average number of parallel statements that were running during the 1-minute metric window |
|
|
|
The average number of parallel statements that were queued during the 1-minute metric window |
|
|
|
The average number of parallel servers that were actively running as part of a parallel statement during the 1-minute metric window |
|
|
|
The average number of parallel servers that were requested by queued parallel statements during the 1-minute metric window |
|
|
|
The number of parallel servers allowed to be used by this consumer group during the 1-minute metric window |
|
|
|
Resource Manager plan name |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“STATISTICS_LEVEL”
