Re: How to delete a lock

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 07 Aug 2006 20:21:30 -0700
Message-ID: <1155007279.150982@bubbleator.drizzle.com>

dn.perl_at_gmail.com wrote:
> HansF wrote:

>> - you may terminate the session manually using the
>>    'alter system kill session' command
>>   as described in the "SQL Language Reference" manual for
>>   the version of database you use.  (see http://docs.oracle.com)
>>

>
> Hmmm... that site says :
>
> You can identify the Oracle session ID for an RMAN channel by looking
> in the RMAN log for messages with the format shown in the following
> example:
>
> channel ch1: sid=15 devtype=SBT_TAPE
>
> Never having heard about RMAN before, I poked around a bit,
> looked for one .opt file which seemed to be important under
> $ORACLE_HOME/rman dir, but did not find it. Anyway, it seems
> that I can find parameters to 'alter system kill session' from
> table v$session itself. So I ran :
> alter system kill session '7, 93'
> and got the message :
> Error at line 1
> ORA-00031: session marked for kill ;
> And serial# for SID=7 in v$session changed from 93 to 97.
>
> What next? Please help.
>
> ----------------

Go to www.psoug.org and click on Morgan's Library. Scroll down to Killing Sessions.

But before you do anything else run this:

SELECT status
FROM gv$session
WHERE sid = <sid>
AND serial# = <serial#>;

What is the status?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Aug 07 2006 - 22:21:30 CDT