Re: How to delete a lock

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.
>
> ----------------

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 Received on Tue Aug 08 2006 - 01:22:44 CDT