Systems Engineering and RDBMS

  • Click Here for Decipher's Homepage

  • Categories

  • Questions?

    Please send your wish list of things that you would like us to write about or if you have suggestions to help improve this blog site. You can send all questions/suggestions to: Blog Support
  • Archives

  • Blog Stats


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: