Re: Unlocking Locked records

A request for a url which will access a PL/SQL procedure(s) via Oracle Web Application Server will create a cartridge instance which then logs onto the database, executes the procedure(s) and then logs off, automatically causing a commit ( unless using session enabled cartridges ). If rows are being locked then my guess is that the cartridge instances are not lgging out of the database due to an error.

Check the wrb.log file (down in the OWA directory somewhere, on NT)

This should provide details of cartridge creation and deletion for each request....

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Pete Bretz wrote in message <36E92E1A.D1171CFF_at_haleypro.com>...
>
>
>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 Mon Mar 15 1999 - 06:48:12 CST