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

FINALLY ,
Everything is good now.
Thank you for your replies.

Bunyamin

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, June 28, 2002 12:33 AM

> I suspect that if you are getting 4030s with 50 concurrent users that
> you will get NO benefit from MTS, in fact it will likely cause just the
> problems you are seeing and you will start to get 4030s sooner than you
> would have before.
>
> MTS is not appropriate as a tool to address your 4030 errors if the
> sessions are not inactive for more than a few seconds. If the concurrent
> sessions are very active (check v$session's last_call_et field) and you
> are still running into 4030s than MTS will not help you, and can
> actually cause a performance hit (CPU) that is scary. The key thing to
> remember is that MTS provides SCALABILITY, performance is indirectly
> affected if at all.
>
> If you are running into 4030s there are a number of other approaches you
> can take as well. Application tuning is the best place to start, but
> more often then not, not possible. Then go to the obvious (that others
> have mentioned) like using statspack to get a look at the usage of your
> buffer cache. In your case you may have to reduce the size of your SGA
> to allow for more user space. Don't fall for the buffer cache hit ratio
> needs to be x%. If you are in an application env where most blocks are
> rarely seen in more than one query then you need a different approach to
> buffer cache tuning than hit %. This is a book in and of itself, but
> fairly intuitive.
>
> Given that you are stuck with your current application, the very first
> thing you also will want to look at is the Orastack utility to reduce
> the memory usage of each server process' stack. I have seen DBAs in your
> situation have their 4030s resolved with this alone.
>
> The other is upgrading your OS (or properly setting it) to NT EE or
> Win2k AS. This will allow you to use a 3gb process size. If you haven't
> done this it will surely fix your memory shortage (at least until you
> get another 50 users :)).
>
> You can also scale out by adding more nodes with OPS, although I'd
> strongly suggest that you move to 9i before doing this! Finally, you can
> use OPS/RAC on a single box, a bit of a fancy trick, but it allows you
> to have multiple instances if you have the system memory available.
>
> Ramble, ramble, ramble, for more info you can come to my presenation at
> OpenWorld (or just send more info/questions!)
>
> Regards,
>
> Michael Sale
> Author: Oracle9i for Windows(R) 2000 Tips & Techniques
> http://www.amazon.com/exec/obidos/ASIN/0072194626
>
>
> -----Original Message-----
> Karadeniz
> Sent: Thursday, June 27, 2002 8: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: Michael P 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).