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_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>

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