DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003

    killing blocking sessions

    how do set up an automated process which will wake up at given intervals, identify and kill sessions that are blocking other sessions for a variable (and configurable) period of time?
    mine is on sun 2.6

  2. #2
    Join Date
    Feb 2001
    Paris, France
    maybe you should use Oracle profile, look for the syntax of the SQL order : CREATE PROFILE in the doc

    hoping you'll find killing criteria you need in the available list

  3. #3
    Join Date
    Nov 2000
    Create a script in which,

    Identify a blocking session, get its sid & serial#
    If blocking session there,
    run alter system kill session "sid,serial#";

    Run this script in cron on Unix or as a scheduled job on Windows.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width