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

2 votes135 views1 answer
Sql column values comma separated
SQL
0 vote151 views1 answer
How to inner join 4 tables in sql
SQL
13 votes127 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote132 views1 answer
Mysql convert charset
SQL
14 votes159 views3 answers
Inner join sql oracle
SQL
0 vote161 views1 answer
Pgadmin save data greyed out
SQL
1 vote125 views2 answers
Mysql type conversion
SQL
0 vote154 views1 answer
No suitable driver found for sqlite
SQL
0 vote128 views1 answer
Test connection to sql server
SQL
0 vote132 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL