open cursor number grows in a session
45508Sep 1 2004 — edited Sep 2 2004we have a Java app, that's executing prepared statements (and explicitly closing them). The numbers of cursors for that session is growing constantly in the V$OPEN_CURSOR. We have multiple cursors open for identical parametrized DML statements. We've already reached exceeded open_cursors once and got an error.
Here is our DB settings:
cursor_space_for_time=FALSE
session_cached_cursors=0
cursor_sharing=EXACT
open_cursors=1000
So here is the question:
1. when are cursors from v$open_cursor are deallocated? I thought closing a java perepared statement should do.
2. Is there anything that can be done on the DB side (other than setting open_cursor insanely high) to alleviate this problem of open cursros just growing and growing?