V$EVENT_NAME definition in Oracle Database 11.2
V$EVENT_NAME

select
  event#,                                  -- EVENT# NUMBER
  event_id,                                -- EVENT_ID NUMBER
  name,                                    -- NAME VARCHAR2(64)
  parameter1,                              -- PARAMETER1 VARCHAR2(64)
  parameter2,                              -- PARAMETER2 VARCHAR2(64)
  parameter3,                              -- PARAMETER3 VARCHAR2(64)
  wait_class_id,                           -- WAIT_CLASS_ID NUMBER
  wait_class#,                             -- WAIT_CLASS# NUMBER
  wait_class                               -- WAIT_CLASS VARCHAR2(64)
from
  gv$event_name
where
  inst_id = USERENV('Instance')

home |  up