Oracle教程 2023-04-05

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

本站中文解释

_MAPPING

Oracle视图V$RSRC_CONSUMER_GROUP_MAPPING用于显示访问资源管理器分配给每个消费组，以便管理动态工作负载和优先级访问资源的信息。

V$RSRC_CONSUMER_GROUP_MAPPING视图可将消费组映射到各资源管理器。它显示两列：RESOURCE_MANAGER_ID和CONSUMER_GROUP_ID它们表示每一个消费组的一对对应的资源管理器ID。

使用方法：

可以使用V$RSRC_CONSUMER_GROUP_MAPPING视图来检索当前正在活动的资源管理器和消费组的映射。例如：

SELECT resource_manager_id, consumer_group_id FROM v$rsrc_consumer_group_mapping;

官方英文解释

V$RSRC_CONSUMER_GROUP displays data related to currently active resource consumer groups.

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.

Statistics in V$RSRC_CONSUMER_GROUP are reset when a pluggable database (PDB) changes its resource plan. They are not impacted by multitenant container database (CDB) resource plan changes.

Since PDB plans can be set independently across different PDBs, V$RSRC_CONSUMER_GROUP will not cover the same time period across different PDBs. Therefore, this view is not useful for comparing statistics across different PDBs.

Column	Datatype	Description
`ID`	`NUMBER`	Consumer group object ID (a unique number, consistent across database shutdowns and startups)
`NAME`	`VARCHAR2(32)`	Name of the consumer group
`ACTIVE_SESSIONS`	`NUMBER`	Number of currently active sessions in the consumer group
`EXECUTION_WAITERS`	`NUMBER`	Number of currently active sessions waiting for an execution time slice in which they will be able to use CPU
`REQUESTS`	`NUMBER`	Cumulative number of requests that were executed in the consumer group
`CPU_WAIT_TIME`	`NUMBER`	Cumulative amount of time that sessions waited for CPU on the resmgr: cpu quantum wait event 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.
`CPU_WAITS`	`NUMBER`	Cumulative number of times all sessions in the consumer group had to wait for CPU on the resmgr: cpu quantum wait event because of resource management. 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.
`CONSUMED_CPU_TIME`	`NUMBER`	Cumulative amount of CPU time consumed by all sessions in the consumer group (in milliseconds)
`YIELDS`	`NUMBER`	Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration. When CPU resources are not being actively managed, this value is set to zero.
`CPU_DECISIONS`	`NUMBER`	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.
`CPU_DECISIONS_EXCLUSIVE`	`NUMBER`	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.
`CPU_DECISIONS_WON`	`NUMBER`	Percentage of the CPU decisions that the consumer group won. When CPU resources are not being actively managed, this value is set to zero.
`QUEUE_LENGTH`	`NUMBER`	Number of sessions waiting in the queue
`CURRENT_UNDO_CONSUMPTION`	`NUMBER`	Current amount (in KB) of undo consumed by the consumer group
`ACTIVE_SESSION_LIMIT_HIT`	`NUMBER`	Number of times that sessions in the consumer group were queued because the consumer group reached its active session limit
`UNDO_LIMIT_HIT`	`NUMBER`	Number of times that queries in the consumer group were canceled because the consumer group reached its `UNDO_POOL` limit
`SWITCHES_IN_CPU_TIME`	`NUMBER`	Number of switches into the consumer group because of the Resource Manager plan’s `SWITCH_TIME` limit
`SWITCHES_OUT_CPU_TIME`	`NUMBER`	Number of switches out of the consumer group because of the Resource Manager plan’s `SWITCH_TIME` limit
`SWITCHES_IN_IO_MEGABYTES`	`NUMBER`	Number of switches into the consumer group because of the Resource Manager plan’s `SWITCH_IO_MEGABYTES` limit
`SWITCHES_OUT_IO_MEGABYTES`	`NUMBER`	Number of switches out of the consumer group because of the Resource Manager plan’s `SWITCH_IO_MEGABYTES` limit
`SWITCHES_IN_IO_REQUESTS`	`NUMBER`	Number of switches into the consumer group because of the Resource Manager plan’s `SWITCH_IO_REQS` limit
`SWITCHES_OUT_IO_REQUESTS`	`NUMBER`	Number of switches out of the consumer group because of the Resource Manager plan’s `SWITCH_IO_REQS` limit
`SWITCHES_IN_IO_LOGICAL`	`NUMBER`	Number of switches into the consumer group because of the Resource Manager plan’s `SWITCH_IO_LOGICAL` limit
`SWITCHES_OUT_IO_LOGICAL`	`NUMBER`	Number of switches out of the consumer group because of the Resource Manager plan’s `SWITCH_IO_LOGICAL` limit
`SWITCHES_IN_ELAPSED_TIME`	`NUMBER`	Number of switches into the consumer group because of the Resource Manager plan’s `SWITCH_ELAPSED_TIME` limit
`SWITCHES_OUT_ELAPSED_TIME`	`NUMBER`	Number of switches out of the consumer group because of the Resource Manager plan’s `SWITCH_ELAPSED_TIME` limit
`SQL_CANCELED`	`NUMBER`	Number of times that SQL queries running in the consumer group were aborted because they exceeded one of the Resource Manager plan’s `SWITCH` limits and `CANCEL_SQL` was specified as the Resource Manager plan’s `SWITCH_GROUP`
`ACTIVE_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions running in the consumer group were terminated because they exceeded one of the Resource Manager plan’s `SWITCH` limits and `KILL_SESSION` was specified as the Resource Manager plan’s `SWITCH_GROUP`
`IDLE_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions in the consumer group were killed because they were idle for too long (reached `MAX_IDLE_TIME`)
`IDLE_BLKR_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions in the consumer group were killed because they were idle too long (reached `MAX_IDLE_BLOCKER_TIME`) and were blocking other sessions
`QUEUED_TIME`	`NUMBER`	Total amount of time that sessions in the consumer group have spent in the QUEUED state because of the active session limit (in milliseconds)
`QUEUE_TIME_OUTS`	`NUMBER`	Number of times that requests from sessions in the consumer group timed out because they were queued for too long (reached `QUEUEING_P1`)
`IO_SERVICE_TIME`	`NUMBER`	Cumulative I/O wait time (in milliseconds)
`IO_SERVICE_WAITS`	`NUMBER`	Total number of wait requests
`SMALL_READ_MEGABYTES`	`NUMBER`	Number of single block megabytes read
`SMALL_WRITE_MEGABYTES`	`NUMBER`	Number of single block megabytes written
`LARGE_READ_MEGABYTES`	`NUMBER`	Number of multiblock megabytes read
`LARGE_WRITE_MEGABYTES`	`NUMBER`	Number of multiblock megabytes written
`SMALL_READ_REQUESTS`	`NUMBER`	Number of single block read requests
`SMALL_WRITE_REQUESTS`	`NUMBER`	Number of single block write requests
`LARGE_READ_REQUESTS`	`NUMBER`	Number of multiblock read requests
`LARGE_WRITE_REQUESTS`	`NUMBER`	Number of multiblock write requests
`CURRENT_PQS_ACTIVE`	`NUMBER`	Number of active parallel statements in the consumer group. This value does not include parallel statements that are never queued, such as GV$ queries.
`CURRENT_PQ_SERVERS_ACTIVE`	`NUMBER`	Number of active parallel servers in the consumer group. This value does not include servers running parallel statements that are never queued, such as GV$ queries.
`PQS_QUEUED`	`NUMBER`	Number of times that sessions in the consumer group were queued when trying to run parallel statements
`PQS_COMPLETED`	`NUMBER`	Total number of completed parallel statements in the consumer group
`PQ_SERVERS_USED`	`NUMBER`	Total number of parallel servers used by completed parallel statements in the consumer group
`PQ_ACTIVE_TIME`	`NUMBER`	Cumulative sum of the parallel active times for all completed parallel statements in the consumer group (in milliseconds)
`CURRENT_PQS_QUEUED`	`NUMBER`	Number of sessions in the consumer group that are waiting in the parallel statement queue trying to run parallel statements
`PQ_QUEUED_TIME`	`NUMBER`	Total amount of time that sessions in the consumer group were queued when trying to run parallel statements (in milliseconds)
`PQ_QUEUE_TIME_OUTS`	`NUMBER`	Number of times that parallel statements from sessions in the consumer group timed out because their queue time exceeded the Resource Manager plan’s `PARALLEL_QUEUE_TIMEOUT` limit
`PGA_LIMIT_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions in the consumer group were killed because their untunable PGA usage exceeded the `SESSION_PGA_LIMIT` limit
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. 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

本站中文解释

官方英文解释

相关推荐