Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to timeout SQLNet connection?

Re: How to timeout SQLNet connection?

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 13 Dec 2006 21:23:59 +0000
Message-ID: <be592d550612131323t287a2e04o86b6a00b8a4fe74a@mail.gmail.com>


use idle_time in profiles,

but ar eyou sure they arent a connection pool which you want to keep open?

On 13/12/06, Dhimant Patel <drp4kri_at_gmail.com> wrote:
>
> 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.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 13 2006 - 15:23:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US