How to break a lock?

I'm running Workgroup Server 7.3.4 in a web application environment -
Oracle webserver 2.1.1.  I am having  problem with one table developing
locked rows, even though the user is done modifying records.  Any
suggestions on:

1. how do I clear the locked records
2. troubleshoot why they are remaining locked in the first place.


Ans1:
A commit or rollback should free the locked records. Is the user commiting
after he's done modifying ?

Denny


Ans2:
Sorry if this is too simplistic, but is the user somehow leaving a
transaction without committing/rolling back? Is there some GUI bug that
causes a transaction to remain open under some circumstances?

Ans3:
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
 

Hosted by www.Geocities.ws

1