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

From: MICHAEL.SALE <MICHAEL.SALE_at_oracle.com>
Date: Thu, 27 Jun 2002 05:53:17 -0800
Message-ID: <F001.0048A3E2.20020627055317@fatcity.com>

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

Received on Thu Jun 27 2002 - 08:53:17 CDT