Re: Dedicated Server versus Shared Server

Just to confuse the issue more, you can have an instance allow both shared server and dedicated server processing.

• Forwarded by Tracy Rahmlow on 05/16/2002 04:28 PM

  ---

       PM PST Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:

Hello Eriovaldo,

I think you mean shared mode is multithreaded configuration.

The multithreaded server configuration (MTS) allows many user processes to share very few server processes. The user processes connect to a dispatcher background process, which routes client requests to the next available shared server process.
The advantage of the multithreaded server configuration is that system overhead is reduced, increasing the number of users that can be supported. A small number of shared server processes can perform the same amount of processing as many dedicated server processes, and the amount of memory required for each user is relatively small.

You need to add several parameters to your init file to enable MTS: mts_dispatchers
mts_servers

In dedicated mode every connection has it's own server process processing it's data.

The advantages of MTS become valuable when there are several hundred simultaneously connected users (at least) and it's an OLTP application
(server processes consistently wait for user input, etc. I mean server
processes load is relatively small)

Thursday, May 16, 2002, 8:48:21 AM, you wrote:

EA> Hi friends :

EA> What is the diference between The instance in dedicated mode and shared mode
EA> ?

EA> Can I to change the mode from one to other ?

EA> What is the best way ?

EA> Regards

EA> Eriovaldo

--
Best regards,
 Sergey                            mailto:dsv_at_pptus.oilnet.ru


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sergey V Dolgov
  INET: dsv_at_pptus.oilnet.ru

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  INET: tracy.rahmlow_at_aexp.com

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