Re: open_cursor count keeps growing

Moe wrote:
> Hi,
>
> I have a web application that accesses an oracle 10 g database. I
> noticed under home tab an alert saying: current open cursor count is
> 2000. category is database limit.
> My system is getting slower and when i do select count(*) from
> v$open_cursor i get 4200 and keeps growing.
> Im not sure how open cursor works, does oracle close them when they
> are not in use? or do i have something wrong in my application and its
> not closing them?
> My opne_cursor parameter is set to 500.
> Thanks
>
> Moe

Who wrote the application? Your choice is to either fix the application or buy one that is far better designed. This version of this app. was obviously never tested: Or tested well.

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