Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to timeout SQLNet connection?
You could probably cobble something together that looks at V$SESSION,
looks at username or program or whatever to determine which connections
are your JDBC stuff and then look at LAST_CALL_ET > 300 to determine
what's been idle more than 5 minutes.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dhimant Patel
Sent: Wednesday, December 13, 2006 4:10 PM
To: oracle-l
Subject: How to timeout SQLNet connection?
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 13 2006 - 16:49:10 CST
![]() |
![]() |