Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!75g2000cwc.googlegroups.com!not-for-mail
From: "StefanKapitza" <skapitza@volcanomail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to delete a lock
Date: 7 Aug 2006 23:22:44 -0700
Organization: http://groups.google.com
Lines: 41
Message-ID: <1155018164.580658.240370@75g2000cwc.googlegroups.com>
References: <1154994712.576260.177940@p79g2000cwp.googlegroups.com>
   <pan.2006.08.08.00.07.06.35863@gmail.com>
   <1155000420.494624.296190@n13g2000cwa.googlegroups.com>
NNTP-Posting-Host: 212.255.51.204
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155018170 26008 127.0.0.1 (8 Aug 2006 06:22:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 06:22:50 +0000 (UTC)
In-Reply-To: <1155000420.494624.296190@n13g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030225,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 75g2000cwc.googlegroups.com; posting-host=212.255.51.204;
   posting-account=S94O5QwAAACytf2Xn6iObGcxzaKP71O9
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:129125


dn.perl@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.
>
> ----------------

Looks like you are seeing system locks and you try to kill background
processes.
What tables are you seeing in v$locks ?

regards

stefan kapitza