| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:How does oracle assign ports?
Tony,
According to my understanding of this, which may or may not be absolutely true, it depends on the way that connections are established.
In a standard dedicated server connection method, a user originally connects to the listener on port 1521 or whatever else you've selected. Once the initial communications is established, the listener spawns a dedicated server, assigns it a port according to the OS and bequeaths you to that port. So that in this mode you have a one for one correlation of ports and servers.
In a Multi-threaded server scheme, the database starts a number of dispatchers per your settings. These each obtain a port from the OS as required and pass this onto the listener. When a user connects they get bequeathed to the first available server on a round robin basis. In this mode there is no one to one coronation of clients to servers since more than one will be communicating over the one port.
In a connection manager mode, your client initially connects to the connection manager and then gets passed off to the listener. If your using connection pooling the connection manager now manages all inbound/outbound connections over one port I do believe.
There is a lot of 'black magic' here as to which method is best. For the most part, according to an Oracle person I had the privilege of talking to, if you've less than 100 continuos connections to your db, use dedicated server. Between 100 and 500 MTS is best. Above 500 use connection manager with connection pooling.
BTW: That conversation was a privilege since he did a pretty good job of demystifying this subject for me. And to boot his advice appears to have been dead on.
Dick Goulet
____________________Reply Separator____________________ Author: "Barker; Tony" <tbarker_at_doit.state.in.us> Date: 10/23/2001 6:05 AM
How does oracle assign ports to connections? I know the listener is assigned to a port - does all connections use this port for communication? I was looking into using connection manager to limit the number of ports that are assigned to user sessions, but it seems that all my connections are using the listener port? Is this the case? I thought the listener was the initial port of contact and then set up different available ports for post-initial sessions.
Using Oracle 8.1.6.
Thanks in advance for all your responses!!
+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~ Tony Barker - Senior DBA - State of Indiana +~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~+~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barker, Tony
INET: tbarker_at_doit.state.in.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 23 2001 - 09:57:29 CDT
 |
 |