在10gr2中，V$SESSION_WAIT的所有內容都可以在v$session中看到。

V$SESSION_WAIT displays the resources or events for which active sessions are waiting.

V$SESSION_WAIT展示了active的session等待的resources or events 。

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.

P1RAW, P2RAW, and P3RAW 是 P1, P2, and P3 的十六進位制表示

• 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, then you must set the TIMED_STATISTICS initialization parameter to true. Remember that doing this has a small negative effect on system performance.

WAIT_TIME =-2表示所在平臺不支援 fast timing mechanism。如果想要此列顯示等待時間，必須將TIMED_STATISTICS 設定為ture。這將對系統系能帶來一些微小的副作用。

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.

在更早的版本，WAIT_TIME 列使用一個非常大的值來表示所在平臺不支援 fast timing mechanism，而不是負數（如前所述）。

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

 STATE列的數值將影響WAIT_TIME 表達的含義，並且STATE列表示當前狀態還是最近一次等待。