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 vote396 views1 answer
Insert query return id mysql
SQL
-1 vote401 views4 answers
Full outer join in sql
SQL
1 vote378 views1 answer
Tsql update datetime
SQL
49 votes452 views6 answers
Install mysql ubuntu
SQL
1 vote345 views1 answer
Importance of comment in mysql
SQL
10 votes349 views1 answer
Create table oracle
SQL
0 vote408 views1 answer
Drop a view in sqlite
SQL
0 vote346 views1 answer
How to use query in nosql
SQL
10 votes343 views2 answers
Sql rtrim
SQL
3 votes329 views2 answers
Oracle sql truncate table
SQL