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 vote200 views1 answer
Date on SQL
SQL
0 vote215 views1 answer
How to to get time in sql
SQL
0 vote193 views1 answer
Mysql with
SQL
0 vote219 views1 answer
Character count sql
SQL
1 vote204 views1 answer
How to set up a trigger in sql
SQL
1 vote200 views1 answer
SQL: merging multiple row data in string
SQL
0 vote206 views1 answer
MySql Modify Increment
SQL
1 vote257 views1 answer
Drop column if exists sql server
SQL
2 votes208 views1 answer
Guid to string sql
SQL
0 vote229 views1 answer
Show tables in cassandra cql
SQL