Identificar quien bloquea un objeto (ORA-00054) | ExpoDBA

Identificar quien bloquea un objeto (ORA-00054)

Identificar quien bloquea un objeto (ORA-00054)

set linesize 200
col pogram format a40
col program format a50
col machine format a40
col osuser format a10
col username format a12

select s.inst_id, s.sid, s.serial#, lo.PROCESS, s.osuser,
 s.username, s.program, s.machine, lo.LOCKED_MODE
from gv$session s, gv$locked_object lo, dba_objects o
where s.sid = lo.SESSION_ID
and o.object_id = lo.OBJECT_ID
and o.object_type = '&OBLECT_TYPE'
and o.OWNER='&OWNER'
and o.OBJECT_NAME='&OBJECT_NAME';