How to timeout SQLNet connection?
- From: "Dhimant Patel" <drp4kri@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Dec 2006 16:10:19 -0500
Hi All,
I need to timeout incoming JDBC connections to oracle based on how long they
remains idle.
The incoming App Server connections (in this case Coldfusion MX) need to be
closed say after they remain idle for 5 minutes.
This will force oracle to close all cashed cursors and clean up process
global area.
SQLNET.ORA's expire_time doesn't do the job, since it only closes connection
if client has died unexpectedly without cleanly closing the connection.
Any ideas?
-Thanks,
DP.
Other related posts:
