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 vote132 views1 answer
VSCode SQL Server Connection error
SQL
18 votes137 views3 answers
Find column name in database
SQL
1 vote151 views1 answer
Describe table in sql
SQL
0 vote151 views1 answer
What is mysql_pconnect
SQL
-1 vote199 views5 answers
Left join sql
SQL
1 vote133 views1 answer
Mysql get character set
SQL
0 vote136 views1 answer
Oracle create job if not exists
SQL
0 vote153 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote147 views1 answer
Stratified sampling sql
SQL
1 vote151 views1 answer
Full sql mode
SQL