V$SYSTEM_EVENT definition in Oracle Database 11.2
V$SYSTEM_EVENT

select
  event,                                   -- EVENT VARCHAR2(64)
  total_waits,                             -- TOTAL_WAITS NUMBER
  total_timeouts,                          -- TOTAL_TIMEOUTS NUMBER
  time_waited,                             -- TIME_WAITED NUMBER
  average_wait,                            -- AVERAGE_WAIT NUMBER
  time_waited_micro,                       -- TIME_WAITED_MICRO NUMBER
  total_waits_fg,                          -- TOTAL_WAITS_FG NUMBER
  total_timeouts_fg,                       -- TOTAL_TIMEOUTS_FG NUMBER
  time_waited_fg,                          -- TIME_WAITED_FG NUMBER
  average_wait_fg,                         -- AVERAGE_WAIT_FG NUMBER
  time_waited_micro_fg,                    -- TIME_WAITED_MICRO_FG 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$system_event
where
  inst_id = USERENV('Instance')

home |  up