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

7 votes362 views1 answer
Oracle pagination query rownum
SQL
0 vote372 views1 answer
Psql create usr
SQL
21 votes309 views6 answers
Docker run mysql
SQL
3 votes323 views1 answer
Oracle get trigger ddl
SQL
0 vote329 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote321 views1 answer
Cast for print sql
SQL
0 vote328 views1 answer
Psql datestyle
SQL
3 votes361 views1 answer
Sql double index
SQL
1 vote337 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote339 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL