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 vote147 views1 answer
Mariadb cast to int
SQL
2 votes174 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote153 views1 answer
Sql put two columns into one
SQL
0 vote154 views1 answer
T sql return on letters only
SQL
2 votes144 views1 answer
Drop table if exists in postgres
SQL
3 votes158 views1 answer
Oracle get trigger ddl
SQL
10 votes114 views2 answers
Mysql select timestamp group by day
SQL
6 votes143 views4 answers
How to remove unique key in mysql
SQL
0 vote154 views1 answer
Big table in mysql
SQL
0 vote144 views2 answers
Default constraint in ms sql
SQL