Re[2]: Re: Re:MTS performance is too bad.

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" <bunyamink_at_havelsan.com.tr>
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" <ORACLE-L_at_fatcity.com> 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" <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
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> 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.
> >>
> >>
> >> &nbsp;
> >> What can I do ?&nbsp; Have you got an idea.
> > How can
> >>
> >> I check the mts performance?
> >> &nbsp;
> >> Bunyamin
> >>
> >> --
> >> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: MICHAEL.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).

-- 
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: 
  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).