RE: How to timeout SQLNet connection?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 13 Dec 2006 17:49:10 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF270AA24B0B@AABO-EXCHANGE02.bos.il.pqe>

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