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

1 vote340 views1 answer
Print all records of table in mysql
SQL
13 votes312 views2 answers
Mysql order by multiple columns
SQL
0 vote306 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
2 votes338 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote314 views1 answer
Get last week data in mysql
SQL
0 vote329 views1 answer
Sql find record cannot cast date
SQL
9 votes336 views1 answer
No sql
SQL
18 votes292 views4 answers
Foreign key mySql
SQL
3 votes309 views1 answer
Ms sql skip take
SQL
0 vote396 views1 answer
Stop and start mysql
SQL