Inactive sessions not clearing
Posted on 2004-10-07
Oracle 22.214.171.124 on solaris
Application is J2EE through application servers with connection pooling.
During stress testing, a large number of sessions were created. Though for last few days, only a few sessions have been active
but the inactive sessions are not clearing up. we are using "SQLNET.EXPIRE_TIME=10" in sqlnet.ora but it seems to be of no help in this scenario.
we are not using the default listener.
how can we make the inactive sessions clear in this environment ?