Kill inactive cursors

From: Spencer Pieters <spencer.pieters_at_usa.net>
Date: Wed, 23 Dec 1998 16:53:12 +0100
Message-ID: <75r3kn$5vq$1@news3.Belgium.EU.net>

Hello all,

We have an application connected to an Oracle database. There are for example 10 open cursors in the application. For some reason, the connection with the Oracle database is interrupted (problem here, no worries there) and we see that the cursors on the Oracle db remain open ?

Can these automatically be killed ? Is there a "kill-cursors-that-aren't-used-anymore" parameter or summat ?

Cheers,

Spence Received on Wed Dec 23 1998 - 09:53:12 CST