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

I decreased hash_area_size ,
I setted large_pool_size .
I decreased dispatcher number to 4.
And everything is well now.

Bunyamin

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, June 30, 2002 1:18 PM

> How did you solved it?
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, June 28, 2002 4:03 PM
>
>
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> 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).