List Database Session Waits 
--
-- Show all database session waits.
--
 
SET PAUSE on
SET PAUSE 'Press Return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
COLUMN username FORMAT A20
COLUMN event FORMAT A25
COLUMN wait_class FORMAT A20
 
SELECT NVL(s.username, '(oracle)') AS username,
s.sid,
s.serial#,
sw.event,
sw.wait_class,
sw.wait_time,
sw.seconds_in_wait,
sw.state
FROM   v$session_wait sw,
v$session s
WHERE  s.sid = sw.sid
ORDER BY sw.seconds_in_wait DESC
/

Related Scripts

List Summed Database Waits

databaseoraclesessionsqltuningwaits
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License