isitdevops.com/databases

set pages 99
set lines 200

select INST_ID,SID,EVENT,WAIT_TIME,SECONDS_IN_WAIT,STATE FROM gv$session_wait where WAIT_CLASS <> ‘Idle’
order by 1,2
/

/*

select * from v$system_wait_class;

set lines 160
set numwidth 18
col class for a15
col event for a15
col total_waits for 999,999,999
col total_timeouts for 999,999,999
col time_waited for 999,999,999
col average_wait for 999,999,999
select b.wait_class,a.*,c.startup_time
from gv$system_event a,
     gv$event_name b,
     gv$instance c
where a.event=b.name
and (a.time_waited > 0 or a.average_wait > 0)
order by b.wait_class,a.time_waited asc;
*/

exit
=====

set pages 99
set lines 200

select  event, total_waits, total_timeouts, time_waited, average_wait, event_id
from gv$system_event
;