Re: how many connection in one tcpip port?

On 10 Jan 2002 14:41:31 -0800, gang36_at_hotmail.com (hank) wrote:

>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.

Wouldn't you just be able to use any availible ephemeral port? That would put the maximum amount of connection > 60K

B. Received on Fri Jan 11 2002 - 07:42:52 CST