killing blocking sessions

[gregmorris]

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 8.1.7.4 on sun 2.6

[pipo]

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

[Sharma]

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.