select
wait_class_id, -- WAIT_CLASS_ID NUMBER
wait_class#, -- WAIT_CLASS# NUMBER
wait_class, -- WAIT_CLASS VARCHAR2(64)
total_waits, -- TOTAL_WAITS NUMBER
time_waited, -- TIME_WAITED NUMBER
total_waits_fg, -- TOTAL_WAITS_FG NUMBER
time_waited_fg -- TIME_WAITED_FG NUMBER
from
gv$system_wait_class
where
inst_id = USERENV('Instance')