RE: How to timeout SQLNet connection?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <drp4kri@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Dec 2006 17:49:10 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
