Oracle Database 11gR2 Performance Tuning Cookbook

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 ...