How to timeout SQLNet connection?

From: Dhimant Patel <drp4kri_at_gmail.com>
Date: Wed, 13 Dec 2006 16:10:19 -0500
Message-ID: <f3e51c10612131310n3d99c1f6m46a142bcf3e04f80@mail.gmail.com>

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 - 15:10:19 CST