What you get when you read messages in reverse chronological order!! OK, if
you've got memory problems, start with trying to address those first. Can you
decrease the size of the SGA? Cut the DB_BLOCK_BUFFERS back by a third is
possible, limit the shared_pool if you can,and get more memory again if
possible. Oracle is one heck of a memory hog, no matter what platform your on.
Assuming all of that fails to resolve the ORA-4030 errors in dedicated server
mode, then I guess your stuck with going MTS. Rules of thumb that Oracle handed
me is fixing an iTAR:
1) set up one dispatcher for every 50 to 500 connections you expect.
Practice here says experiment around a bit. The capacity of a dispatcher is a
variable on each platform. HP is not exactly happy with more than 52 per
dispatcher.
2) For every dispatcher there is, have a minimum of 2 shared servers. If
you've got 2 dispatchers, which is just about the bottom of the barrel you need
a minimum of 4 shared servers.
3) for every shared server, allocate 100K additional shared pool. This gets
tricky since changing the shared pool means bouncing the database. I read it as
MTS_MAX_SERVERS*100K added to the shared_pool.
4) last watch the utilization of your shared servers. If they all remain
busy more than 50% of the time, up the value os MTS_MIN_SERVERS either in the
init.ora and bounce or via the alter system command.
5) Continue to use decidated servers for all batch load/DML activities.
Leave the MTS stuff for OLTP types of transactions.
6) And after all this, don't really expect an increase in performance, cause
you ain't going to get it.
Dick Goulet
____________________Reply Separator____________________
Author: "Bunyamin Karadeniz" <[EMAIL PROTECTED]>
Date: 6/27/2002 6:33 AM
Michael ,
I have tried all of them , but still performance is very bad. When switch to
dedicated mode I get ora:04030..
Have you ever switched to MTS and seen the same performance , I wonder if
you are sure about MTS performance is good.
What ever I did did not give the same performance as dedicated connections
even not approached.
Bunyamin
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 4:53 PM
> You really don't need MTS with no more than 50 concurrent users unless you
are running into ora-4030s or other memory problems.
>
> When you say performance is a problem, have you check OS swapping of
memory to disk? Your SGA might be too big (with AS and the 3GB switch no
bigger than 3GIG, without the 3GB switch only 2GB) and end up swapping out
to disk.
>
> You also need to make sure that only OLTP users (users with short txns,
NOT long running batch jobs, big updates, etc) are connecting via MTS. All
batch/DSS type users should be connecting via dedicated server. You can have
them specify this in their tnsnames.ora.
>
> That said, your MTS config is WAY out of whack given the number of
concurrent users:
>
> You only need ONE dispatcher to start with. Change dispatchers to 1 unless
you have multiple NICs you are working off of for a particular segmentation
of users. (50 dispatchers would be appropriate for about 12,000 Concurrent
users....)
>
> If your total number of concurrent OLTP users is truly 50 set your min
servers to 60. Max servers is fine.
>
> You should also set your large pool instead of a massive shared pool, all
kinds of reason for doing this!!
>
> If you have a chance go to borders or barnes and noble, sit down and read
chapter 7 (Oracle Connectivity) of my book "Oracle9i for Windows 2000 Tips &
Techniques". It covers the setup, monitoring and basic tuning of MTS.
>
> I hope this helps,
>
> Mike Sale
>
>
>
> >
> > 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
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> 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
> >>
> >> --
> >> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: MICHAEL.SALE
> 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:
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).
