Re: TNSNAMES.ORA QUEUESIZE?

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@xxxxxxxxxx> 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.
>
> ****************************************************************************
>

Other related posts: