Finding Locked objects in Oracle

posted Jan 13, 2011, 6:31 AM by Sachchida Ojha
select s.sid, s.serial#, p.spid
from v$session s, v$process p
where s.paddr = p.addr
and s.sid in (select SESSION_ID from v$locked_object);
Comments