Posts tagged: blocking session details in Oracle 10g

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;

Alibi3col theme by Themocracy