Connection session is not closing on Oracle data base |
|
| Comments (2) |
|
rakesh in Bow, United Kingdom 11 months ago |
On database sever lot of INACTIVE database connection sessions are still open from last 2 days .
1. Connection timeout
2. Maximum connections
3. Minimum connections
4. Reap time
5. Unused timeout
6. Aged timeout
7. Statement cache size
8. Purge policy
Could you please suggest me on this issue. |
|
SD in Bridgewater, New Jersey 5 months ago |
rakesh in Bow, United Kingdom said: On database sever lot of INACTIVE database connection sessions are still open from last 2 days . When I faced a similar issue, I changed the min connection to 0, since the application was small enough to be able to afford a new connection everytime connections in the pool went back to 0. |
Your Reply
change location - create a profile
Subscribe to this discussion as an RSS feed.
