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

4 votes218 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
2 votes159 views1 answer
Oracle create directory
SQL
0 vote279 views1 answer
How to update random rows in sql
SQL
2 votes192 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote173 views2 answers
Sql server set default value equal to auto increment
SQL
3 votes204 views3 answers
Docker create postgresql database
SQL
2 votes163 views1 answer
Oracle cpu per session
SQL
0 vote189 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote174 views1 answer
Mysql decimal allow negative values?
SQL
1 vote180 views1 answer
Mysql count all table rows
SQL