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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
