Re: open_cursor count keeps growing

Moe wrote:
> A developer at my company. I believe he is missing to close the cursors
> somewhere.
> is oracle supposed to take care of that automatically or the
> application should close it?.
> I know that i can flush shared_pool but open_cursor are located in the
> PGA, is that correct?
> Is it possible to flush the PGA instead of restarting the database
> untill we figure out the problem with the application?
>
> Moe

Depends on the way the code was written. Without seeing the code it is impossible to tell.

What I can tell you is that any developer that doesn't test their code ... should be escorted to the nearest Burger King and given an application that is more in tune with their skill set.

Flush nothing. Make the developer fix it and test it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)