V$SESSION_WAIT

This view lists the resources or events for which active sessions are waiting.

The following are tuning considerations:

• P1RAW, P2RAW, and P3RAW display the same values as the P1, P2, and P3 columns, except that the numbers are displayed in hexadecimal.

• The WAIT_TIME column contains a value of -2 on platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you want this column to reflect true wait times, you must set the TIMED_STATISTICS parameter to TRUE. Remember that doing this has a small negative effect on system performance.

  In previous releases the WAIT_TIME column contained an arbitrarily large value instead of a negative value to indicate the platform did not have a fast timing mechanism.

• The STATE column interprets the value of WAIT_TIME and describes the state of the current or most recent wait.

  See Also: "TIMED_STATISTICS" and Appendix A, "Oracle Wait Events".

  Column	Datatype	Description
  SID	NUMBER	Session identifier
  SEQ#	NUMBER	Sequence number that uniquely identifies this wait. Incremented for each wait.
  EVENT	VARCHAR2(64)	Resource or event for which the session is waiting. See Also: Appendix A, "Oracle Wait Events"
  P1TEXT	VARCHAR2	Description of first additional parameter
  P1	NUMBER	First additional parameter
  P1RAW	RAW(4)	First additional parameter
  P2TEXT	VARCHAR2	Description of second parameter
  P2	NUMBER	Second additional parameter
  P2RAW	RAW(4)	Second additional parameter
  P3TEXT	VARCHAR2	Description of third parameter
  P3	NUMBER	Third additional parameter
  P3RAW	RAW(4)	Third additional parameter
  WAIT_TIME	NUMBER	A non-zero value is the session's last wait time. A zero value means the session is currently waiting
  SECONDS_IN _WAIT	NUMBER	The seconds in wait
  STATE	VARCHAR2	Wait state: 0: WAITING (the session is currently waiting) -2: WAITED UNKNOWN TIME (duration of last wait is unknown) -1: WAITED SHORT TIME (last wait <1/100th of a second) >0: WAITED KNOWN TIME (WAIT_TIME = duration of last wait)