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 vote163 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote172 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote217 views1 answer
TSQL Find csv file in folder
SQL
0 vote145 views1 answer
Mysql workbench indent formatting
SQL
2 votes171 views3 answers
How to get second highest salary in each department in sql
SQL
1 vote155 views1 answer
MySQL AND Operator
SQL
0 vote154 views2 answers
Create row number in sql
SQL
4 votes149 views1 answer
Id primary key auto generated
SQL
34 votes186 views6 answers
Install mysql client ubuntu
SQL
0 vote151 views1 answer
Acual month sql
SQL