Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$RSRC_CONSUMER_GROUP

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.

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 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.
CPU_WAITS NUMBER Cumulative number of times all sessions in the consumer group had to wait for CPU 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 the Resource Manager plan's SWITCH_TIME limit 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 the Resource Manager plan's SWITCH_TIME limit 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
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


See Also: