RE: Re: Re:MTS performance is too bad.

So far, I did not see what is the specific performance problem here.

I support one of the five warehouses that has over 300 users and we implemented dedicated servers but we ended up with heavy disk swap because application had external call procedure which gets Unix timestamp from Oracle. This resulted in holding/ never releasing the Unix processes. So we switched to MTS and requested application to use Oracle timestamp instead.

Our MTS parameters:
mts_servers=4 Start up 4 servers
dispatcher=10
mts_max_servers=20

shared pool=360mb

Performance is as good as dedicated servers. I implemented on all other four warehouses. Our MTS has been running for over 8 months now.

-----Original Message-----
Sent: Thursday, June 27, 2002 7:33 AM
To: Multiple recipients of list ORACLE-L

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: Wong, Bing
  INET: bing.wong_at_IngramMicro.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).