Oracle locked objects

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;

Source: dba-oracle.com

Similar codes

0 vote109 views1 answer
Import mysql'
SQL
0 vote120 views1 answer
Sqlite get date only
SQL
3 votes119 views3 answers
Order by postgres
SQL
0 vote114 views1 answer
Sql developer search all packages for text
SQL
5 votes122 views1 answer
AND OR NOT operators sql
SQL
0 vote118 views2 answers
What is 1=2 in sql
SQL
5 votes114 views1 answer
Oracle nls parameters
SQL
0 vote104 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote122 views1 answer
For row in sql database python loop
SQL
0 vote115 views2 answers
How to update date in oracle
SQL