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: 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).
Received on Thu Jun 27 2002 - 06:38:19 CDT
