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. 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. NULL if the session has not yet logged in. |
MAPPING_ATTRIBUTE |
VARCHAR2(32) |
The session attribute that was used to map the session into its original consumer group. NULL if no mapping was used. For more details see "DBA_RSRC_GROUP_MAPPINGS". |
MAPPED_CONSUMER_GROUP |
VARCHAR2(32) |
The 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. For more details see "DBA_RSRC_GROUP_MAPPINGS". |
STATE |
VARCHAR2(32) |
Current state of the session:
|
ACTIVE |
VARCHAR2(5) |
Indicates if the session is currently active. This includes when one of the following conditions is true:
|
CURRENT_IDLE_TIME |
NUMBER |
Number of seconds the session has been idle (in states IDLE or IDLE BLKR) while in this consumer group. This field is reset to 0 when the session becomes active. NULL if the current resource manager plan does not require updating this statistic. |
CURRENT_CPU_WAIT_TIME |
NUMBER |
Amount of time the session has waited for CPU (in WAIT FOR CPU state) while in the current consumer group. If SWITCH_TIME_IN_CALL is used, this will be reset at the end of every call. NULL if the current resource manager plan does not require updating this statistic. |
CPU_WAIT_TIME |
NUMBER |
Cumulative amount of time the session has waited for CPU (in its lifetime). |
CURRENT_CPU_WAITS |
NUMBER |
Number of times the session had to wait for CPU while in this consumer group. If SWITCH_TIME_IN_CALL is used, this will be reset at the end of every call. NULL if the current resource manager plan does not require updating this statistic. |
CPU_WAITS |
NUMBER |
Cumulative number of times the session had to wait for CPU (in its lifetime). |
CURRENT_CONSUMED_CPU_TIME |
NUMBER |
Amount of CPU time consumed by the session while in the current consumer group. If SWITCH_TIME_IN_CALL is used, this will be reset at the end of every call. NULL if the current resource manager plan does not require updating this statistic. |
CONSUMED_CPU_TIME |
NUMBER |
Cumulative amount of CPU time consumed by the session in its lifetime |
CURRENT_ACTIVE_TIME |
NUMBER |
Amount of time session has been active while in the current consumer group. 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 this is reset at the end of every call. NULL if the current resource manager plan does not require updating this statistic. |
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 QUEUED state). If the session does not have a request currently queued up, 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 session had to yield the CPU to other sessions (due to quantum expiration) while in the current consumer group. If SWITCH_TIME_IN_CALL is used this is reset at the end of every call. NULL if the current resource manager plan does not require updating this statistic. |
YIELDS |
NUMBER |
Cumulative number of times session had to yield CPU to other sessions due to quantum expiration (in its lifetime) |
CURRENT_UNDO_CONSUMPTION |
NUMBER |
Current amount (in kilobytes) of undo consumed by the session. NULL if the current resource manager plan does not have an UNDO_POOL directive. |
MAX_UNDO_CONSUMPTION |
NUMBER |
The maximum amount of undo consumed (in kilobytes) during this sessions lifetime. This field 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 this session were canceled due to exceeding the resource manager plan's SWITCH_TIME limit. |
QUEUE_TIME_OUTS |
NUMBER |
Number of times requests from this session timed out because they queued longer than the resource manager plan's limit. |
ESTIMATED_EXECUTION_LIMIT_HIT |
NUMBER |
Number of times requests from this session were not run because the optimizers estimated time to execute the query exceeded the MAX_EST_EXEC_TIME limit |