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 votes291 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote279 views1 answer
Postgres select from values
SQL
3 votes254 views1 answer
Oracle nextval
SQL
-1 vote322 views1 answer
Difference berween database and data base management system
SQL
1 vote260 views1 answer
Primary key reset in SQL database
SQL
0 vote293 views1 answer
Insert into Select * - NAYCode.com
SQL
1 vote256 views1 answer
Postgres format date in select
SQL
-1 vote267 views2 answers
How to select the lowest values from table per client sql
SQL
11 votes265 views4 answers
Query DISTINCT
SQL
0 vote258 views2 answers
Clear window pl sql
SQL