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')