| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re:MTS performance is too bad.
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 <ORACLE-L_at_fatcity.com>
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" <ORACLE-L_at_fatcity.com>
> 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" <ORACLE-L_at_fatcity.com>
> > 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" <bunyamink_at_havelsan.com.tr>
> > > 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: dgoulet_at_vicr.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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Bunyamin Karadeniz
> > INET: bunyamink_at_havelsan.com.tr
> >
> > 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).
> >
>
> --------------------------------------------------------------------------
> ----
> > 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: Yechiel Adar INET: adar76_at_inter.net.il 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 Thu Jun 27 2002 - 10:03:30 CDT
 |
 |