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 vote139 views1 answer
Sql server isnull function nor working count
SQL
4 votes141 views1 answer
Oracle nls_date_format
SQL
-1 vote122 views1 answer
Sql getdate date only
SQL
5 votes124 views1 answer
Sql use database
SQL
0 vote146 views1 answer
Check if mysql db is used
SQL
0 vote170 views1 answer
Ms sql print more than 1 variable
SQL
0 vote133 views1 answer
Soql queries for not contact related account records in salesforce
SQL
3 votes127 views1 answer
Show index table
SQL
0 vote136 views1 answer
Get date from timestamp in mysql
SQL
0 vote135 views1 answer
How to find top 3 salary in sql
SQL