Re: How to delete a lock

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.