Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how many connection in one tcpip port?

Re: how many connection in one tcpip port?

From: hank <gang36_at_hotmail.com>
Date: 10 Jan 2002 14:41:31 -0800
Message-ID: <8d54c48d.0201101441.5153dc78@posting.google.com>


pagesflames_at_usa.net (Dusan Bolek) wrote in message news:<1e8276d6.0201100421.3fbae10e_at_posting.google.com>...
> gang36_at_hotmail.com (hank) wrote in message news:<8d54c48d.0201091401.34f6362a_at_posting.google.com>...
> > Does anybody know in LISTENER default tcpip port setup (like 1251) how
> > many simultaneous connection can be allowed in dedicate server, and
> > how can configure it if we need to increase the connection?
>
> This setup is called dedicated, but not dedicated !port! connection,
> so there is no limit like this (users per listener port). We have had
> 1000+ dedicated connections to one instance and limit was definitely
> not in port overcrowding. :-)
> The limits are usually memory available, processes or threads number
> limit and some other kernel limits. Everything depends on platform
> used. When running UNIX based system then carefully selected kernel
> parameters, lot of memory in box can take you in the skies. However I
> fear that for NTs 1000 users in dedicated mode is pretty close to hard
> limit.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.

thanks Dusan, you are right it is not dedicate port!

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 Thu Jan 10 2002 - 16:41:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US