Powered By Blogger

Wednesday, March 2, 2011

Killing session in oracle

Finding session:

SQL> select SID,serial# from v$session where username='TESTER'

and Killing it


SQL> ALTER SYSTEM KILL SESSION '2090,4043'IMMEDIATE;

No comments:

Post a Comment

Welcome to the UNIX world