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 vote232 views2 answers
Csv into data postgres
SQL
0 vote225 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote245 views1 answer
Change magento database url usimg musql
SQL
0 vote234 views1 answer
Cast for print sql
SQL
0 vote237 views1 answer
Sql_inner_join
SQL
0 vote230 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote194 views1 answer
Count char in java
SQL
0 vote257 views2 answers
Sql auto update dupdated_at
SQL
0 vote242 views1 answer
Install squirrel sql ubuntu
SQL
0 vote242 views1 answer
How to Remove milliseconds from Date time
SQL