7. Wait related DBA queries..

SELECT distinct wait_class#, wait_class FROM v$event_name ORDER BY wait_class#;

SELECT wait_class_id, wait_class#, wait_class, total_waits, time_waited
FROM v$system_wait_class
order by time_waited desc;