Breaking News: Grepper is joining You.com. Read the official announcement!

oracle locked objects

VasteMonde answered on July 10, 2021 Popularity 6/10 Helpfulness 5/10

answer oracle locked objects

oracle locked objects

Comment

SELECT (SELECT USERNAME FROM v$session WHERE SID = a.SID) AS blocker,
       a. SID,
       ' is blocking ',
       (SELECT USERNAME FROM v$session WHERE SID = b. SID) AS blockee,
       b. SID
FROM v$lock a,
     v$lock b
WHERE a.BLOCK = 1 AND b.REQUEST > 0 AND a.ID1 = b.ID1 AND a.ID2 = b.ID2;

Popularity 6/10 Helpfulness 5/10 Language sql

Source: www.dba-oracle.com

Tags: locked oracle sql

Link to this answer
Share Copy Link