Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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_CONS_GROUP_HISTORY

V$RSRC_CONS_GROUP_HISTORY provides a history of consumer group statistics for each entry in V$RSRC_PLAN_HISTORY that has a non-NULL plan.

Column Datatype Description
SEQUENCE# NUMBER 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.
ID NUMBER The consumer group object ID. A unique number, consistent across database shutdowns and startups.
NAME VARCHAR2(30) The consumer group name
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
CPU_WAITS NUMBER Cumulative number of times all sessions in the consumer group had to wait for CPU
CONSUMED_CPU_TIME NUMBER Cumulative amount of CPU time consumed by all sessions in the consumer group
YIELDS NUMBER Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration
ACTIVE_SESS_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 cancelled because the consumer group reached its UNDO_POOL limit
SESSION_SWITCHES_IN NUMBER Number of times that sessions switched into the consumer group. This does not include the number of times a session started in the consumer group (this is displayed by the REQUESTS column).
SESSION_SWITCHES_OUT NUMBER Number of times that sessions switched out of the consumer group to a different consumer group
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_SESS_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_SESS_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_SESS_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
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)