Re: How to timeout SQLNet connection?

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: drp4kri@xxxxxxxxx
  • Date: Wed, 13 Dec 2006 21:23:59 +0000

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@xxxxxxxxx> 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.

Other related posts: