Re: Inactive Cursors

From: Ryan <rgaffuri_at_cox.net>
Date: Sat, 01 Jun 2002 01:08:00 GMT
Message-ID: <Q7VJ8.24273$ok.955866@news2.east.cox.net>

you really need to close your cursors when you are done with them right in the PL/SQL code. Your problem is similiar to a memory leak in C.

You can increase the number of open cursors allowed in your init.ora but that will not solve your problem. Tracking down nameless cursors is REALLY hard since they are not tracked by any type of naming convention in the data dictionary.

You absolutely have to spend the time to track these downs or your problem will never be fixed. Rebooting will fix it temporarily, however, it will keep happening.

"Derek" <snekse_at_hotmail.com> wrote in message news:979919aa.0205311023.5bf2d56a_at_posting.google.com...
> Is there a way to kill inactive cursors?
Received on Fri May 31 2002 - 20:08:00 CDT