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_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. 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:
  • 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 "V$SESSION_WAIT" for wait type

  • UNBOUND: Session is not bound to any process

  • EXITING: Session is about to terminate

ACTIVE VARCHAR2(5) Indicates if the session is currently active. 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 hold 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. 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