kill session that holds lock for more then 10 sec

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.

thanks,
Doron Received on Mon Jan 12 2004 - 12:11:40 CST