Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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: Shevtsov, Eduard <EShevtsov_at_flagship.ru>
Date: Thu, 28 Dec 2000 18:07:51 +0300
Message-Id: <10724.125390@fatcity.com>


Hi Srini,

it was posted by Vladimir Begun to russian forum some days ago.

to wake up PMON:

SVRMGR> select pid from v$process p, v$bgprocess b
      > where b.paddr = p.addr 
      > and name='PMON';
PID       
----------
         2

1 row selected.

SVRMGR> oradebug wakeup 2
Statement processed.
SVRMGR> Ed

>
>
> 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
Received on Thu Dec 28 2000 - 09:07:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US