V$SESSION_EVENT definition in Oracle Database 11.2
V$SESSION_EVENT

select
  sid,                                     -- SID NUMBER
  event,                                   -- EVENT VARCHAR2(64)
  total_waits,                             -- TOTAL_WAITS NUMBER
  total_timeouts,                          -- TOTAL_TIMEOUTS NUMBER
  time_waited,                             -- TIME_WAITED NUMBER
  average_wait,                            -- AVERAGE_WAIT NUMBER
  max_wait,                                -- MAX_WAIT NUMBER
  time_waited_micro,                       -- TIME_WAITED_MICRO NUMBER
  event_id,                                -- EVENT_ID NUMBER
  wait_class_id,                           -- WAIT_CLASS_ID NUMBER
  wait_class#,                             -- WAIT_CLASS# NUMBER
  wait_class                               -- WAIT_CLASS VARCHAR2(64)
from
  gv$session_event
where
  inst_id = USERENV('Instance')

home |  up