Home » RDBMS Server » Server Administration » question on Inactive connection?
icon5.gif  question on Inactive connection? [message #116292] Tue, 19 April 2005 04:55 Go to next message
lff0305
Messages: 1
Registered: April 2005
Junior Member
We are developing a web application based on Oacle 9i and Tomcat(Struts & Hibernate ).But after the DBServe was startedup for about 5~6 hours, the max connection process exceeded. From the DB Administration Tool it shows that there were many INACTIVE Connections which executed

SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'

But it seems that this is called by the JDBC driver, not our code. How to avoid this, or release the inactive connection?
Thanks.

Report message to a moderator

Re: question on Inactive connection? [message #116304 is a reply to message #116292] Tue, 19 April 2005 06:00 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
As workaround, kill the idle sessions:

1. Set SQLNET.EXPIRE_TIME in you sqlnet.ora file; or
2. Enable RESOURCE_LIMIT for your DB and create a profile to limit IDLE_TIME.

Best regards.

Frank

Report message to a moderator

Re: question on Inactive connection? [message #116421 is a reply to message #116292] Tue, 19 April 2005 22:54 Go to previous message
chunyuh
Messages: 13
Registered: April 2005
Junior Member
If you really want to develop a real web application , the web/app layer should not connect to the database directly. Add a connection pool in the app layer.

Chunyu Hu
http://mtsmart.kmip.net

Report message to a moderator

Previous Topic: A problem on Win2k + Oracle, Thank you!
Next Topic: Cloband BLoB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 04:49:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.