Re: Inactive Cursors

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 1 Jun 2002 12:36:45 -0700
Message-ID: <a8aed4.0206011136.35a6a894@posting.google.com>

Hi,

Why do you need to Restart the server.

Wont Alter System flush Shared_Pool;

Do the trick. Correct me if i am wrong.

[I Know it is Wrong advice but still wanted to clarify]

Regards,
Ganesh R

"Ryan" <rgaffuri_at_cox.net> wrote in message news:<Q7VJ8.24273$ok.955866_at_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 Sat Jun 01 2002 - 14:36:45 CDT