May
24
2010
Query to display blocked session and their blocking session details in Oracle 10g
SELECT sid, serial#, blocking_session_status, blocking_session
FROM v$session
WHERE blocking_session IS NOT NULL;
SELECT sid, serial#, blocking_session_status, blocking_session
FROM v$session
WHERE blocking_session IS NOT NULL;
Alibi3col theme by
Themocracy