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

6 votes419 views2 answers
Oracle compile trigger
SQL
0 vote341 views1 answer
How to insert multiple rows in mysql using laravel
SQL
36 votes399 views6 answers
Change column data type sql
SQL
17 votes365 views4 answers
Show tables sql server
SQL
0 vote318 views1 answer
Alter precision
SQL
0 vote333 views1 answer
Trigger value from maltiple table to single table mysql
SQL
5 votes368 views3 answers
Postgres show databases
SQL
2 votes345 views1 answer
Query to find table size in oracle 12c
SQL
0 vote383 views1 answer
Mysql create index lost connection
SQL
1 vote332 views1 answer
Sqlite check if row exists
SQL