V$SESSION

This view displays information on each current session.

Fields

The most relevant view fields are as follows:

• SID: The session identifier

• SADDR: The session address

• SERIAL#: The session serial number

• PROCESS: The operating system client process ID

• PADDR: The address of the process that owns this session

• AUDSID: The auditing session ID

• EVENT: The resource or event for which the session is waiting

• P1, P2, P3: Wait event parameters

• WAIT_TIME: This is set to:

  • -2 if TIMED_STATISTICS is set to false

  • -1 if the last wait duration was less than a hundredth of a second

  • 0 if the session is currently waiting

  • A value greater than zero, which is the duration of the last wait in hundredths of a second

• LAST_CALL_ET: The elapsed time in seconds since the session has become active/inactive

• SQL_ID: The identifier of the currently executed SQL statement

• PREV_SQL_ID: The identifier of the last SQL statement executed

• ROW_WAIT_BLOCK#: The identifier for the block containing the row specified in ROW_WAIT_ROW#

• ROW_WAIT_ROW#: The current row being locked

• ROW_WAIT_FILE#: The file identifier for the datafile containing the row specified in ROW_WAIT_ROW#

• ROW_WAIT_OBJ#: The object ID for the table containing the row specified in ROW_WAIT_ROW#

See also

• The V$SESSION_EVENT and V$SESSTAT sections in this appendix