SELECT (SELECT COUNT (1)
FROM v$session a2
WHERE a2.blocking_session IS NOT NULL
AND a2.SID = a1.blocking_session) r_count,
a1.blocking_session,
(SELECT a2.serial#
FROM v$session a2
WHERE a2.SID = a1.blocking_session) blocking_serial, a1.SID,
a1.serial#, a1.wait_class, a1.module, a1.seconds_in_wait, a1.action
FROM v$session a1
WHERE a1.blocking_session IS NOT NULL AND a1.blocking_session <> 1693
ORDER BY 1;
FROM v$session a2
WHERE a2.blocking_session IS NOT NULL
AND a2.SID = a1.blocking_session) r_count,
a1.blocking_session,
(SELECT a2.serial#
FROM v$session a2
WHERE a2.SID = a1.blocking_session) blocking_serial, a1.SID,
a1.serial#, a1.wait_class, a1.module, a1.seconds_in_wait, a1.action
FROM v$session a1
WHERE a1.blocking_session IS NOT NULL AND a1.blocking_session <> 1693
ORDER BY 1;
留言
張貼留言