Oracle Database Discussions

Hi


Some of the tables ot locked in my database(it is 4 node RAC) so i first identified the session id and serial has to kill the session using belo query

col oracle_username for a10
col os_user_name for a10
set linesize 150
select s.sid,s.serial#,s.inst_id,l.inst_id,l.session_id,l.oracle_username,l.XIDUSN,l.XIDSLOT,l.XIDSQN,l.OBJECT_ID,
l.OS_USER_NAME,l.PROCESS,l.LOCKED_MODE
from gv$session s,gv$locked_object l
where s.sid=l.session_id
and ORACLE_USERNAME='&USERNSME';

it gaves me below result


       168        202          1          1        168 TEST123           72          0      34994      35239 test123   6652            3

so i tried to kill it using below command

alter system kill session '168,202,@1' immediate;

but i m getting below error

SQL> ALTER SYSTEM KILL SESSION '168,202,@1' IMMEDIATE;
ALTER SYSTEM KILL SESSION '168,202,@1' IMMEDIATE
*
ERROR at line 1:
ORA-00030: User session ID does not exist.

plz suggest how do i kill session in oracle rac