Re: kill session that holds lock for more then 10 sec

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 13 Jan 2004 11:47:03 +0100
Message-ID: <bu0ib8$q00$1@news.fujitsu-siemens.com>

"Paul Drake" <drak0nian_at_yahoo.com> schrieb im Newsbeitrag news:1ac7c7b3.0401122252.dcaf2d9_at_posting.google.com...
> ALTER SYSTEM KILL SESSION is not the way to go.
>
> you could conceivably wait hours for the session to be killed and the
> lock(s) to be released.
> don't go with a DBMS_JOB, schedule an OS task so that you can leverage
> orakill.exe. that will seriously kill a session.
>
> basically, use a batch file to call sqlplus.
> in sqlplus run a script to spool an orakill script
> quit sqlplus and execute the spooled .bat file
> for bonus points, you could log the offending user that held the lock
> too long (although 60 seconds seems to be a little too short to me).
>
> D:\oracle\ora81\bin>orakill

Does something like this exist on unix too?

Lots of Greetings!
Volker Received on Tue Jan 13 2004 - 04:47:03 CST