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