会话等待（Session Waits）
-- -----------------------------------------------------------------------------------
-- File Name : http://www.oracle-base.com/dba/10g/session_waits.sql
-- Author : DR Timothy S Hall
-- Description : Displays information on all database session waits.
-- Requirements : Access to the V$ views.
-- Call Syntax : @session_waits
-- Last Modified: 11/03/2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 200
SET PAGESIZE 1000
COLUMN username FORMAT A20
COLUMN event FORMAT A30
COLUMN wait_class FORMAT A15
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;
-- File Name : http://www.oracle-base.com/dba/10g/session_waits.sql
-- Author : DR Timothy S Hall
-- Description : Displays information on all database session waits.
-- Requirements : Access to the V$ views.
-- Call Syntax : @session_waits
-- Last Modified: 11/03/2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 200
SET PAGESIZE 1000
COLUMN username FORMAT A20
COLUMN event FORMAT A30
COLUMN wait_class FORMAT A15
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;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22558114/viewspace-1097822/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SQL优化
下一篇：
ASH AWR ADDM
请登录后发表评论
登录
全部评论
