We are using the ORACLE A.S 10g and D.B 10g (10.0.1). We maintain a pool of D.B connection on A.S. Our application is web based. We are properly closing the resultset and statement on
java side. But we often receive the
error open cursor exceeded. Currently on production we set the limit to 5000.
We use following query to check the currently open cursor
The count of
open cursor is increasing it cannot be reduce until we restart our application server.
Because we are using the connection pooling that is why cursors are not closed?
Please advice us what should we do. What other areas should we look.
Thanks