Real Time Wait Events
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.
