V$RSRC_SESSION_INFO

V$RSRC_SESSION_INFO displays Resource Manager statistics per session.

Column	Datatype	Description
`SID`	`NUMBER`	Session identifier
`CURRENT_CONSUMER_GROUP_ID`	`NUMBER`	Object ID of the consumer group in which the session currently belongs; NULL if the session has not yet logged in
`ORIG_CONSUMER_GROUP_ID`	`NUMBER`	Object ID of the consumer group in which the session was placed by the consumer group mappings; NULL if the session has not yet logged in This group may not be the current group because the `SWITCH_GROUP` directive in the current plan may have changed the session's current group. This group may not equal the `MAPPED_CONSUMER_GROUP` because the `MAPPED_CONSUMER_GROUP` may not be part of the current plan.
`MAPPING_ATTRIBUTE`	`VARCHAR2(32)`	Session attribute that was used to map the session into its original consumer group; NULL if no mapping was used See Also: "DBA_RSRC_GROUP_MAPPINGS" for more details
`MAPPED_CONSUMER_GROUP`	`VARCHAR2(32)`	Consumer group to which the session was originally mapped; NULL if no mapping was used This may not correspond to the original consumer group, because the mapped group may not be part of the current plan. See Also: "DBA_RSRC_GROUP_MAPPINGS" for more details
`STATE`	`VARCHAR2(32)`	Current state of the session: `NOT MANAGED` - Session has not logged in or the current Resource Manager plan does not require the session to be managed at this point in time `RUNNING` - Session is currently running on the CPU `WAITING FOR CPU` - Session is ready to run. It is waiting for a CPU quantum to run. `QUEUED` - Session is queued because the active session limit was reached `IDLE` - Session is idle `IDLE BLKR` - Session is idle and blocking another session `WAITING` - Session is currently in a wait See Also: "V$SESSION_WAIT" for the wait type `WAITING_FOR_IO` - Session is waiting to submit an I/O request `UNBOUND` - Session is not bound to any process `EXITING` - Session is about to terminate
`ACTIVE`	`VARCHAR2(5)`	Indicates whether the session is currently active (`TRUE`) or not (`FALSE`). This includes when one of the following conditions is true: Session is in the top call Session has a transaction in progress Session is using temporary space objects Session holds user enqueues
`CURRENT_IDLE_TIME`	`NUMBER`	Number of seconds the session has been idle (in states `IDLE` or `IDLE BLKR`) while in this consumer group; NULL if the current Resource Manager plan does not require updating this statistic. This value is reset to zero when the session becomes active.
`CURRENT_CPU_WAIT_TIME`	`NUMBER`	Amount of time the session has waited for CPU because of resource management (in state `WAIT FOR CPU`) while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. This does not include waits due to latch or enqueue contention, I/O waits, and so on. If `SWITCH_TIME_IN_CALL` is used, then this will be reset at the end of every call.
`CPU_WAIT_TIME`	`NUMBER`	Cumulative amount of time the session has waited for CPU (in its lifetime) because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on.
`CURRENT_CPU_WAITS`	`NUMBER`	Number of times the session had to wait for CPU because of resource management while in this consumer group; NULL if the current Resource Manager plan does not require updating this statistic. This does not include waits due to latch or enqueue contention, I/O waits, and so on. If `SWITCH_TIME_IN_CALL` is used, then this will be reset at the end of every call.
`CPU_WAITS`	`NUMBER`	Cumulative number of times the session had to wait for CPU (in its lifetime) because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on.
`CURRENT_CONSUMED_CPU_TIME`	`NUMBER`	Amount of CPU time consumed by the session while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. If `SWITCH_TIME_IN_CALL` is used, then this will be reset at the end of every call.
`CONSUMED_CPU_TIME`	`NUMBER`	Cumulative amount of CPU time consumed by the session (in its lifetime)
`CURRENT_ACTIVE_TIME`	`NUMBER`	Amount of time the session has been active while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. Active time is time spent running and waiting while executing a call. It does not include the time a session waited for CPU resources. If `SWITCH_TIME_IN_CALL` is used, then this is reset at the end of every call.
`ACTIVE_TIME`	`NUMBER`	Cumulative amount of active time consumed by the session (in its lifetime)
`CURRENT_QUEUED_TIME`	`NUMBER`	Amount of time the current request from the session has been queued (in state `QUEUED`). If the session does not have a request currently queued up, then this number will be zero.
`QUEUED_TIME`	`NUMBER`	Total amount of time the session has spent in the QUEUED state (in its lifetime)
`CURRENT_YIELDS`	`NUMBER`	Number of times the session had to yield the CPU to other sessions (due to quantum expiration) while in the current consumer group; NULL if the current Resource Manager plan does not require updating this statistic. If `SWITCH_TIME_IN_CALL` is used, then this is reset at the end of every call.
`YIELDS`	`NUMBER`	Cumulative number of times the session had to yield CPU to other sessions due to quantum expiration (in its lifetime)
`CURRENT_UNDO_CONSUMPTION`	`NUMBER`	Current amount (in KB) of undo consumed by the session; NULL if the current Resource Manager plan does not have an `UNDO_POOL` directive
`MAX_UNDO_CONSUMPTION`	`NUMBER`	Maximum amount of undo consumed (in KB) during the session's lifetime. This value may not be updated because the current Resource Manager plan may not have an `UNDO_POOL` directive.
`SQL_CANCELED`	`NUMBER`	Number of times SQL queries running in the session were canceled due to exceeding the Resource Manager plan's `SWITCH_TIME` limit.
`QUEUE_TIME_OUTS`	`NUMBER`	Number of times requests from the session timed out because they queued longer than the Resource Manager plan's limit
`ESTIMATED_EXECUTION_LIMIT_HIT`	`NUMBER`	Number of times requests from the session were not run because the optimizer's estimated time to execute the query exceeded the `MAX_EST_EXEC_TIME` limit
`CURRENT_IO_SERVICE_TIME`	`NUMBER`	Current I/O wait time of the session (in milliseconds)
`IO_SERVICE_TIME`	`NUMBER`	Cumulative amount of I/O wait time by the session (in its lifetime)
`CURRENT_IO_SERVICE_WAITS`	`NUMBER`	Current I/O waits by session
`IO_SERVICE_WAITS`	`NUMBER`	Cumulative I/O waits by session (in its lifetime)
`CURRENT_SMALL_READ_MEGABYTES`	`NUMBER`	Number of single block megabytes read by the session
`SMALL_READ_MEGABYTES`	`NUMBER`	Total number of single block megabytes read by the session (in its lifetime)
`CURRENT_LARGE_READ_MEGABYTES`	`NUMBER`	Number of multiblock megabytes read by the session
`LARGE_READ_MEGABYTES`	`NUMBER`	Total number of multiblock megabytes read by the session (in its lifetime)
`CURRENT_SMALL_WRITE_MEGABYTES`	`NUMBER`	Number of single block megabytes written by the session
`SMALL_WRITE_MEGABYTES`	`NUMBER`	Total number of single block megabytes written by the session (in its lifetime)
`CURRENT_LARGE_WRITE_MEGABYTES`	`NUMBER`	Number of multiblock megabytes written by the session
`LARGE_WRITE_MEGABYTES`	`NUMBER`	Total number of multiblock megabytes written by the session (in its lifetime)
`CURRENT_SMALL_READ_REQUESTS`	`NUMBER`	Number of single block read requests by the session
`SMALL_READ_REQUESTS`	`NUMBER`	Total number of single block read requests by the session (in its lifetime)
`CURRENT_SMALL_WRITE_REQUESTS`	`NUMBER`	Number of single block write requests by the session
`SMALL_WRITE_REQUESTS`	`NUMBER`	Total number of single block write requests by the session (in its lifetime)
`CURRENT_LARGE_READ_REQUESTS`	`NUMBER`	Number of multiblock read requests by the session
`LARGE_READ_REQUESTS`	`NUMBER`	Total number of multiblock read requests by the session (in its lifetime)
`CURRENT_LARGE_WRITE_REQUESTS`	`NUMBER`	Number of multiblock write requests by the session
`LARGE_WRITE_REQUESTS`	`NUMBER`	Total number of multiblock write requests by the session (in its lifetime)