open_cursor count keeps growing
From: Moe <mwahidi_at_emanagelaw.com>
Date: 14 Sep 2005 15:17:26 -0700
Message-ID: <1126736245.967905.307270_at_g49g2000cwa.googlegroups.com>
Hi,
Date: 14 Sep 2005 15:17:26 -0700
Message-ID: <1126736245.967905.307270_at_g49g2000cwa.googlegroups.com>
Hi,
[Quoted] 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 Received on Thu Sep 15 2005 - 00:17:26 CEST