my.indeed - Create Account - Sign in
 

Connection session is not closing on Oracle data base

Get new comments by email
You can cancel email alerts at anytime.
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 .
And Aged timeout on websphere is 0 .Is it the reason behind this problem?
In our code we have closed all ResultSet,Statement , Connection objects.
All server settings for datasource are fine, which are as below

1. Connection timeout
1000 s.

2. Maximum connections
30

3. Minimum connections
7

4. Reap time
180

5. Unused timeout
2000

6. Aged timeout
0

7. Statement cache size
100

8. Purge policy
entire pool

Could you please suggest me on this issue.

Was this comment helpful? Yes / No Reply - Report abuse

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 .
And Aged timeout on websphere is 0 .Is it the reason behind this problem?
In our code we have closed all ResultSet,Statement , Connection objects.
All server settings for datasource are fine, which are as below

1. Connection timeout
1000 s.

2. Maximum connections
30

3. Minimum connections
7

4. Reap time
180

5. Unused timeout
2000

6. Aged timeout
0

7. Statement cache size
100

8. Purge policy
entire pool

Could you please suggest me on this issue.

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.

Was this comment helpful? Yes / No Reply - Report abuse

Your Reply

change location - create a profile
Your Name
 in Santa Monica, California
Your Comment
Your Email Address
Enter the numbers you see in the box
CAPTCHA Image

Be Reasonable! Be Polite! Please read our Terms of Service, where it notes that you are responsible for your own comments. You may post anonymously - but we reserve the right to remove inappropriate comments at any time.

RSS Feed Icon Subscribe to this discussion as an RSS feed.