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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dedicated Server versus Shared Server

Re: Dedicated Server versus Shared Server

From: Sergey V Dolgov <dsv_at_pptus.oilnet.ru>
Date: Wed, 15 May 2002 19:23:18 -0800
Message-ID: <F001.00461DF7.20020515192318@fatcity.com>


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). Received on Wed May 15 2002 - 22:23:18 CDT

Original text of this message

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