Systems Engineering and RDBMS

Generate Kill Session Script in Oracle

Posted by decipherinfosys on March 14, 2007

Small tid-bit:

A simple script to generate the KILL session commands in Oracle:

select ‘ALTER SYSTEM KILL SESSION ”’||sid||’,’||serial#||”’;’
From v$session where schemaname = ‘<schema_name>’
/

Sorry, the comment form is closed at this time.

 
%d bloggers like this: