This content has been marked as final.
Show 1 reply
-
1. Re: open cursors and prepared statement cache size
smaring Jan 16, 2004 9:10 PM (in response to smaring)Well, I removed the "<prepared-statement-cache-size>" element from my oracle-ds.xml and configured <min-pool-size> to 10, instead of 1. My <idle-timeout-minutes> is 1
So far it seems to be doing the trick. I think what is happening is that my connections that get put back in the pool are sitting around idle long enough to be recycled and have their Oracle session, along with the cursors, KILLED like the dirty rotten bastards that they are!
hehehe