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

19 votes196 views2 answers
Mysql add column after another
SQL
2 votes209 views1 answer
Column names in oracle sql
SQL
0 vote196 views1 answer
Select in select sql
SQL
3 votes195 views1 answer
Oracle apex call duration
SQL
4 votes193 views4 answers
What is primary key
SQL
23 votes210 views6 answers
Create table sql server
SQL
0 vote183 views1 answer
Joins vs includes
SQL
0 vote199 views1 answer
Get number of tables in database sql
SQL
0 vote196 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
16 votes218 views3 answers
Get count of duplicate records
SQL