TCP Open Connections
89163Apr 8 2003 — edited Apr 18 2003Hi,
We have an issue of TCP Connections that are not closing. I presume this is from memory leaks but I'm not sure how best to pinpoint the problem areas. We are in a large scale production environment and the open connections is a drain on our resources (basically, this is quite urgent).
We have successfully implement connection pooling and AM pooling, and our actual database connections are much less than our TCP Open Connections...which is confusing. We just recently implemented connection pooling in hopes that it would halt our open connection issues, and it has at the database level but not with our app server.
We are using standalone OC4J version 9.0.2.1 with JDev 902 (going to 903 is not an option at this time). Any ideas on this issue and how to resolve it????
I'm providing a snippet of our data-sources.xml and start script for our OC4J. Any ideas would be much appreciated!
<data-sources>
<data-source class="oracle.jdbc.pool.OracleConnectionCacheImpl" connection-driver="oracle.jdbc.driver.OracleDriver" ejb-location="jdbc/CGFNS_DEVDS" max-connections="200" min-connections="25" wait-timeout="5" inactivity-timeout="60" location="jdbc/CGFNS_DEVCoreDS" name="CGFNS_DEVDS" password="XXXX" pooled-location="jdbc/CGFNS_DEVPooledDS" url="XXXX" username="XXXX" xa-location="jdbc/xa/CGFNS_DEVXADS"/>
</data-sources>
OC4J Start script:
-DApplicationServerDebug=true -DNativeJDBCDebug=true -Djsp.library.loading.debug=true -Doc4j.userThreads=true -Djbo.doconnectionpooling=true -Djbo.poolmaxinactiveage=300000 -Djbo.poolmonitorsleepinterval=100000 -Djbo.poolrequesttimeout=5 -Djbo.recyclethreshold=2 -Djbo.ampool.maxavailablesize=5 -Djbo.ampool.minavailablesize=1 -Djbo.ampool.maxinactiveage=100000 -Djbo.ampool.monitorsleepinterval=300000 -Xms256mb -Xmx1000mb -jar /export/spare/oracle/oc4j9021/j2ee/home/oc4j.jar -verbosity 10 >> log/oc4jlog.log 2>&1
Thanks!
Andy