Hello Bunyamin I seem to miss something here. If you have up to 50 concurrent users why do you use min_servers =100? I think that you waste a lot of storage this way and this can cause the computer to page a lot.
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:38 PM > I agree with you but that will not help me in performance ... > Bunyamin > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 12:28 PM > > > > Bunyamin, > > > > You probably only need about 2 dispatchers. I think Oracle suggest 1 > > dispatcher for every 1000 users but that figure seems a little low to me, > > I'd work on the basis of 1 dispatcher for every 500. > > > > As for shared servers, work on the basis of 1 for every 10 users. > > > > Try this.... > > > > mts_servers = 5 > > mts_max_servers = 10 (increase if needed) > > dispatchers = 2 > > > > Ade > > > > -----Original Message----- > > Sent: 27 June 2002 09:18 > > To: Multiple recipients of list ORACLE-L > > > > > > mts_max_servers=750 > > mts_min_servers=100 > > dispatchers=50 > > users total 750 > > users concurrent at most 50 > > > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, June 26, 2002 9:58 PM > > > > > > > Bunyamin, > > > > > > What is MTS_MAX_SERVERS & MTS_MIN_SERVERS set to? Also what is the > > total > > > number of users connecting to the database? > > > > > > Dick Goulet > > > > > > ____________________Reply Separator____________________ > > > Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> > > > Date: 6/26/2002 8:49 AM > > > > > > I have changed my 8.1.7.3.2 database to MTS on win2000. But performance > is > > too > > > bad. > > > I have 800 MB of shared pool and not setted large_pool_size. > > > 50 dispathers, 100 processes and 750 max processes. > > > > > > What can I do ? Have you got an idea. How can I check the mts > > performance? > > > > > > Bunyamin > > > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > > > <HTML><HEAD> > > > <META http-equiv=Content-Type content="text/html; charset=iso-8859-9"> > > > <META content="MSHTML 6.00.2600.0" name=GENERATOR> > > > <STYLE></STYLE> > > > </HEAD> > > > <BODY bgColor=#ffffff> > > > <DIV><FONT face=Arial size=2>I have changed my 8.1.7.3.2 database to MTS > > on > > > win2000. But performance is too bad. </FONT></DIV> > > > <DIV><FONT face=Arial size=2>I have 800 MB of shared pool and not setted > > > large_pool_size. </FONT></DIV> > > > <DIV><FONT face=Arial size=2>50 dispathers, 100 processes and 750 max > > processes. > > > > > > </FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>What can I do ? Have you got an idea. > > How can > > > > > > I check the mts performance?</FONT></DIV> > > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > > <DIV><FONT face=Arial size=2>Bunyamin </FONT></DIV></BODY></HTML> > > > > > > -- > > > 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). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Bunyamin Karadeniz > > 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). > > > > -------------------------------------------------------------------------- > ---- > > Live Life in Broadband > > www.telewest.co.uk > > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. > > Statements and opinions expressed in this e-mail may not represent those > of the company. Any review, retransmission, dissemination or other use of, > or taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender immediately and delete the material > from any computer. > > > > > > > ============================================================================ > == > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Adrian Roe > > 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: Bunyamin Karadeniz > 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: Yechiel Adar 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).