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