Identify Locked object in Oracle Database:
select s.sid, s.serial#, p.spid,s.osuser, s.username,s.SQL_HASH_VALUE,s.status,s.machine,s.program,s.module,s.LOGON_TIME
from
v$session s,
v$process p
where
s.paddr = p.addr
and
s.sid in (select SESSION_ID from v$locked_object);
select * from v$sql where hash_value=4260304665;
select * from v$session where sid=591;
Tags: