V$SESSION_WAIT_HISTORY View
Historical information has been lacking from the Oracle wait events views. Low-level historical data simply doesn’t exist, and DBAs have to rely on high-level data from V$SESSION_EVENT, V$SYSTEM_EVENT
and the Statspack utility for performance diagnosis. This view retains the 10 most recent wait events for each connected session. This is not a complete history, but it is a step in the right direction.
V$SESSION_WAIT_HISTORY从10g开始为每个session保留了等待事件的历史信息,其对应的字段如下:SQL> desc V$SESSION_WAIT_HISTORY;
Name Type Nullable Default Comments
---------- ------------ -------- ------- --------
SID NUMBER Y
SEQ# NUMBER Y
EVENT# NUMBER Y
EVENT VARCHAR2(64) Y