Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unlocking Locked records
tim.mcconechy_at_runtime.dk wrote:
> 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
My real problem in this is that I can't determine who's doing the locking. This is a web application where a web request broker is essentially executing any SQL with the database. Only a couple of users have been having this difficulty, and I'm not sure if they are doing the locking or the web request broker is properly unlocking records.
Will killing the locked sessions at least temporarily free up access to the records, or do I need to restart the database?
Pete
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 12 1999 - 09:09:14 CST