Most probably, it's not Oracle, it's your application, that does not allow
oracle to release memory.
Are you closing your connections properly?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July
Hi Neyman,
Thanks for your quick response. I use connection pool. Initially it makes 25
connection objects and put in the pool and they are reused. Not closed.
But I close prep statements and resultset after using it, but to no avail.
Any idea?
Thanks
Joshy
-Original Message-
Sent:
Joshy,
In some versions of 8i there were bug related to OCI driver where
closing Statements and ResultSet aren't enough, you have to close
Connection which is obviously not good for connection pooling.
Not sure if 9i could have this problem too.
Also, check on how you close the Statements and