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

    • 7,311,714 Views

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: