Oracle Database Administration Blog » Query to display blocked session and their blocking session details in Oracle 10g

Posts tagged: Query to display blocked session and their 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;

Database Administration | aarthimudhalvan | Comments (0)

blocking session details in Oracle 10g, Query to display blocked session and their blocking session details in Oracle 10g, V$SESSION

Alibi3col theme by Themocracy