RIYOSU

Wait Event Time

select INST_ID||':'||EVENT,time_waited from gv$system_event
order by 1,2;

​

Wait Event Count

select INST_ID||':'||EVENT, TOTAL_WAITS from gv$system_event
order by 1,2;

Download Speedway to graphically plot the above script results.