Session Management - Oracle 10g/11g Data and Database Management Utilities - page 189

• V$SESSION_LONGOPS : This view provides information about tasks that last
more than 6 seconds. This view is useful to monitor the task progress. It is
required to run on cost based optimizer and have the TIMED_STATISTICS or
SQL_TRACE instance parameter to TRUE .
• V$SESSION_OBJECT_CACHE : This view displays object cache statistics for the
current user session on the local instance.
• V$SESSION_WAIT : This view displays the resources or events for which
active sessions are waiting. The columns P1 and P1RAW have the same
value, the difference is that the PnRAW columns display the value in
hexadecimal format. If the WAIT_TIME column has a value of -2 , this means
that the platform does not support the fast timing mechanism and the
TIMED_STATISTICS instance parameter must be set to TRUE .
• V$SESSION_WAIT_CLASS : This view displays the time spent in various wait
event operations on a per-session basis.
• V$SESSION_WAIT_HISTORY : This view displays the last 10 wait events for
each active session.
• V$SESSMETRIC : This view displays the last 10 wait events for each
active session.
• V$SESSTAT : This view lists user session statistics. The statistic name
associated with each statistic number ( STATISTIC# ) can be found in the
V$STATNAME view.
• V$SESS_IO : This view lists I/O statistics for each user session.
• V$SESS_TIME_MODEL : This view displays the session-accumulated time for
various operations.
• V$SES_OPTIMIZER_ENV Displays the contents of the optimizer environment
used by each session.
You may refer to the Oracle documentation for further details on the column
description of each view.