| 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[2]: Re:MTS performance is too bad.
As of 8i and beyond you can bump that up to 200 users before it returns
benefits, this problem is related to memory issues.
Regards,
Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips & Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626
-----Original Message-----
dgoulet_at_vicr.com
Sent: Thursday, June 27, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Pardon me, but I believe I've read somewhere on MetaStink that if your database has less than 150 concurrent users you should not bother with MTS. I've followied that rule of thumb & it does appear correct.
Dick Goulet
____________________Reply Separator____________________ Author: "Yechiel Adar" <adar76_at_inter.net.il> Date: 6/27/2002 7:03 AM
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
> > >
--Received on Thu Jun 27 2002 - 16:08:50 CDT
> ----
> > 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: Adrian.Roe_at_telewest.co.uk
> >
> > 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).
-- 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). -- 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: Michael P Sale INET: Michael.Sale_at_oracle.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).
 |
 |