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,

[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

Original text of this message