Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how many connection in one tcpip port?
On my Solaris 2.6 box, tcp_conn_req_max_q is set to default 128. I
suppose this means at most 128 requests can be queued on a port; the
129th connection will be rejected by the listener. I wonder what
happens if you lower this number and increase the listener queuesize
from its default 5 so that queuesize is higher than
tcp_conn_req_max_q. Probably whichever lower takes effect. Because
Oracle listener processes a request so fast, to test this you may need
to write a shell script to keep looping and connecting (like tnsping)
to the listener.
Yong Huang
yong321_at_yahoo.com
gang36_at_hotmail.com (hank) wrote in message
> but I still think it will overcrowd for the simultaneous connection,
> because the port in listener is only a initial port for tcpip
> connection and then the system give another port to hold the
> connection (you can find it in listener log file), for large number of
> connection oracle provide a parameter QUEUESIZE in listener.ora to
> wait for relocate port number, also in tcp configration it has same
> two parameter tcp_conn_req_max_q and tcp_conn_req_max_q0 for Solari,
> but I can not find the parameter in Windows for tcp queue, and timeout
> for tcpip connection also is a considering isuue, I am looking for a
> optimize in QUEUE SIZE, TIMEOUT and the TIME of RELOCATE PORT,
> otherwise you will get a error TNS: NO LISTENER.
Received on Sat Jan 12 2002 - 00:12:29 CST