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

1 vote290 views1 answer
Mysql date diff in seconds
SQL
0 vote290 views1 answer
How to check which sp is running in sql server
SQL
0 vote298 views1 answer
Add SuperUser MySQL
SQL
2 votes348 views3 answers
Xampp mysql database not starting
SQL
13 votes326 views2 answers
Get date from now() mysql
SQL
0 vote334 views1 answer
Mysql change default collation
SQL
0 vote311 views1 answer
Sql server select value large text
SQL
1 vote307 views4 answers
Mysqldump 1 table only
SQL
1 vote321 views1 answer
How to lock table in mysql
SQL
46 votes367 views4 answers
Create column sql
SQL