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 vote109 views1 answer
Wordpress change http to https phpmyadmin
SQL
8 votes129 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote117 views1 answer
Sql filter rows with condition
SQL
0 vote111 views2 answers
Greater than sql server
SQL
26 votes112 views2 answers
Mysql workbench download
SQL
0 vote104 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
16 votes99 views4 answers
Sort by sql
SQL
9 votes115 views2 answers
Convert data type in sql
SQL
0 vote109 views3 answers
Create and attach user to a postgresql database
SQL
0 vote111 views1 answer
How to use lower case in mysql
SQL