RE: how to increase the connection timeout threshold for an user in Oracle database

  • From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
  • To: <shastry17@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Jan 2008 12:17:15 -0800

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

http://tinyurl.com/ys2wc8

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.


--
//www.freelists.org/webpage/oracle-l


Other related posts: