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

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 12 Jan 2004 19:39:28 +0100
Message-ID: <btupl1$729$1@news.fujitsu-siemens.com>

"Doron" <doron_almog_at_msn.com> schrieb im Newsbeitrag news:995517bc.0401121011.3b9b6799_at_posting.google.com...
> hi,
>
> our application requests exclusive locks at the table level ( i know
> it's very problematic but right now it's a must and i cant change the
> code).
>
> every now and then a user forgets to commit on a crucial table and all
> other users are put in wait. to resolve i have to manually kill the
> user's session.
>
> is it possible to automaticlly kill a session holding an exlusive lock
> for more then a predefined amount of time, lets say 60 sec. i know
> this will cause new problems but i want to give it a try.
Maybe you could have a dbms_job running every 60s and whatever lock by a certain user group shows up at two consecutive runs causes that session to be killed.

Lots of Greetings!
Volker Received on Mon Jan 12 2004 - 12:39:28 CST