Re: Unlocking Locked records

You could try to:

See Who is locked...and what they are doing.. select a.username,a.sid,a.serial#,b.id1,c.sql_text from v$session a, v$lock b, v$sqltext c
where a.lockwait = b.kaddr
and a.sql_Address = c.address
and a.sql_hash_value= c.hash_value

Then see who is locking them and what they are doing???

select a.username,a.sid,a.serial#,b.id1,c.sql_text from v$session a, v$lock b, v$sqltext c
where b.id1 in (select distinct e.id1 from v$session d, v$lock e where d.lockwait=e.kaddr)

and a.sid =b.sid
and c.hash_value = a.sql_hash_value
and b.request=0


-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own