You can setup the Oracle Resource Manager to kill the session when it blocks another session for more than specific ammount of time.
About the query, look at v$session
Regards
|
Results 1 to 3 of 3
Thread: blocking notificationThreaded View
|
Click Here to Expand Forum to Full Width |