RE: how to increase the connection timeout threshold for an user in Oracle database
From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Wed, 23 Jan 2008 12:17:15 -0800
Message-ID: <005b01c85dfc$f2c38220$d84a8660$@net>
Date: Wed, 23 Jan 2008 12:17:15 -0800
Message-ID: <005b01c85dfc$f2c38220$d84a8660$@net>
You can set inbound_connect_timeout for all connections via a particular
TNS_ADMIN or a particular listener, but not for a specific user.
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/performance. htm#sthref1422
Obviously, if the connection is being initiated, then the user is not logged in yet. Therefore it is illogical to hope to apply a connection limit to a specific Oracle user. You could direct an OS user to a specific listener that has a timeout set using the TNS_ADMIN variable.
Regards,
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net
Shastry(DBA) wrote:
> Any idea how to increase the connection timeout threshold for an user in
> Oracle database? Please post your advice.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 23 2008 - 14:17:15 CST