Re: TNSNAMES.ORA QUEUESIZE?
- From: Sheldon Quinny <sheldonquinny@xxxxxxxxx>
- To: lawrence.wolfson@xxxxxxxxxx
- Date: Tue, 25 Jan 2011 10:47:59 +0300
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:
