Significant Events(Oracle 10g)

Submitted by UMBRO
on August 13, 2007 - 10:32pm


SELECT a.event "Event", a.time_waited "Total Time", a.total_waits "Waits",
a.average_wait "Average", a.total_timeouts "Timeouts", b.wait_class
FROM v$system_event a, v$event_name b
WHERE a.event = b.NAME AND b.wait_class NOT IN ('Cluster', 'Idle')
ORDER BY a.event;