Message-Id: <10724.125392@fatcity.com> From: jared still Date: Thu, 28 Dec 2000 07:55:34 -0800 (PST) Subject: Re: Lock not released - Is there anyway to invoke PMON? Kill the OS process, then if the session is still around in v$session, kill it as well. Jared On Thu, 28 Dec 2000, Srinivasan Subramanian kandallu wrote: > Hi All, > The following is the problem as described in one of our client place. > 1. User logs into front-end application which uses Oracle as back-end > database. > 2. User is trying to update some details(Internally one particular table is > locked). > 3. Network connection lost!! > 4. Before network connection reestablished, user closed his application. > > Now, the tables locked by the front-end application, even after 6 hrs > remains in locked state. I dont have anyway other than killing this process > manually, but expecting PMON to do this job(infact,it is one of the > responsibility of PMON). > > Reproducible Test Case!!(Suppose, if anybody wants to try) > > 1. connect to a database which is available in the server using SQLPLUS. Do > it in any of the client machines.(Ensure that database is available in one > machine and you are accessing it over the network). > 2. lock table table_name in exclusive mode > 3. Remove the network cable!! > 4. come out of sqlplus session by doing exit. > 5. Plug-in the network cable. > 6. Now select from v$locked_object to check still the table is in locked > state. > 7. Select from v$session to check the session is still alive. > 7. Wait for PMON to release the lock or till u have patience. > 8. Kill the session holding the lock, since that is the only option u can > do now. > > > Is there anyway to leave this kind of problem to PMON? or Is there anyway > to invoke PMON for handling this kind of situations? > > Thanks in advance. > > Regards, > Srini > > > > > > -------- > Think you know someone who can answer the above question? Forward it to them! > to unsubscribe, send a blank email to oracledba-unsubscribe@LAZYDBA.com > to subscribe send a blank email to oracledba-subscribe@LAZYDBA.com > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;)