Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Lock not released - Is there anyway to invoke PMON?

Re: Lock not released - Is there anyway to invoke PMON?

From: jared still <>
Date: Thu, 28 Dec 2000 07:55:34 -0800 (PST)
Message-Id: <>

Kill the OS process, then if the session is still around in v$session, kill it as well.


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
> to subscribe send a blank email to
> Visit the list archive:

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) Received on Thu Dec 28 2000 - 09:55:34 CST

Original text of this message