Wednesday, June 10, 2009

killing session with instance id

SQL> select inst_id,sid,serial# from gv$session where username='SCOTT';

INST_ID SID SERIAL#
---------- ---------- ----------
1 130 620

SQL> alter system kill session '130,620,@1';