Re: TNSNAMES.ORA QUEUESIZE?

From: Sheldon Quinny <sheldonquinny_at_gmail.com>
Date: Tue, 25 Jan 2011 10:47:59 +0300
Message-ID: <AANLkTik3EjBZua-AJNgLO7nSUh5OWcKtoqDZpyw47OX7_at_mail.gmail.com>



QUEUESIZE
*Purpose*

Use the parameter QUEUESIZE to specify the number of concurrent connection requests that the listener can accept on a TCP/IP or IPC listening endpoint (protocol address).

Embed this parameter at the end of the protocol address with its value set to the expected number of concurrent connection requests.

*Default*

The default number of concurrent connection requests is operating system specific. Following are the defaults for the Solaris Operating System and Windows:

   -

   Solaris Operating System: 5
   -

   Windows NT 4.0 Workstation: 5
   -

   Windows NT 4.0 Server: 50

*Example*

*listener_name*=
 (DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=hr-server)(PORT=1521)*(QUEUESIZE=20)*))

On Tue, Jan 25, 2011 at 12:37 AM, Wolfson Larry - lwolfs < lawrence.wolfson_at_acxiom.com> wrote:

> I just saw this in a new tnsnames.ora file and asked where this came from
>
>
>
> *(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx)(PORT = 1521)(QUEUESIZE = 100
> ))*
>
>
>
> The DBA said they copied it from another tnsnames.ora file we use. Just
> assumed it should be there.
>
> Iíve never used this except in listener.ora files. I Googled it and
> either have the wrong search or itís very hard to find.
>
>
>
> Is this for real? When would you use it? Or is it just ignored?
>
>
>
> TIA
>
> Larry
>
>
>
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
>
> ****************************************************************************
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 25 2011 - 01:47:59 CST

Original text of this message