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 vote268 views1 answer
Trigger
SQL
17 votes212 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote184 views1 answer
Convert sql server guid to varbinary
SQL
0 vote186 views1 answer
Open postgresql.conf in centos
SQL
1 vote194 views1 answer
Oracle show execution plan
SQL
1 vote164 views1 answer
Select dba users oracle
SQL
13 votes186 views3 answers
Change data type postgresql
SQL
1 vote197 views1 answer
Psql connect to another database
SQL
1 vote189 views1 answer
Oracle nvl2
SQL
0 vote975 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL