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 vote335 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote342 views1 answer
Mysql cli output to a file
SQL
2 votes347 views1 answer
Mariadb json select
SQL
0 vote351 views1 answer
Mysqli last row
SQL
10 votes325 views2 answers
Sql rtrim
SQL
0 vote347 views1 answer
Mssql dockere
SQL
0 vote342 views1 answer
Returning with sqlalchemy
SQL
0 vote357 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote372 views2 answers
Oracle leftmost characters
SQL
0 vote341 views1 answer
Drush run sql select
SQL