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.

Complete Database Performance Management