RE: sort latch usage in MTS mode

  • From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxx>, <zhuchao@xxxxxxxxx>, "'Rajeev Prabhakar'" <rprabha01@xxxxxxxxx>
  • Date: Wed, 8 Aug 2007 09:28:40 -0600

Also, it's not called MTS anymore, it's shared server.

RF


Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
BLOG: http://robertgfreeman.blogspot.com/
Sig V1.2

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ted Coyle
  Sent: Wednesday, August 08, 2007 6:28 AM
  To: zhuchao@xxxxxxxxx; 'Rajeev Prabhakar'
  Cc: 'oracle-l'
  Subject: RE: sort latch usage in MTS mode


  "Looks like not much people have the experience with 10g MTS yet."

  Yet?  I hope never..



  MTS is bad, plain and simple.  This falls into my "Don't by a problem"
category.



  Since leaving 8i behind, I've seen MTS as something that should be used as
a short term work-around.

  I've found hardware load balancing and application pooling to be far more
effective without incurring queuing inherent with MTS.



  Ted








----------------------------------------------------------------------------
--

  From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Zhu,Chao
  Sent: Wednesday, August 08, 2007 4:50 AM
  To: Rajeev Prabhakar
  Cc: oracle-l
  Subject: Re: sort latch usage in MTS mode



  Looks like not much people have the experience with 10g MTS yet.
  To Kevin:

  SQL> select * from v$License;

  SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER
USERS_MAX
  ------------ ---------------- ---------------- ------------------ --------
--
             0                0            11474              13293
0

   For sure we use middleware to do connection pooling. We still can't make
the connection below 8-10k for some databases;

  To Alex:
  sort will use large pool in MTS mode. Please check out metalink note
223153.1. It is very easy to reproduce/prove.

  Is there any guys from Amazon type company here in the list? A script
enabled browser is required for this page to function properly. A script
enabled browser is required for this page to function properly.






  On 8/7/07, Rajeev Prabhakar < rprabha01@xxxxxxxxx> wrote:

  Hi Zhu Chao



  Could you please run the following

  query and post the results :



  select * from v$sgastat order by 3 ;



  -Rajeev





  On 8/6/07, Nigel Thomas <nigel_cl_thomas@xxxxxxxxx > wrote:



  Zu Chao wrote: maybe not many people use MTS recently due to nearly-free
RAM. But when connection# goes real high, you still have to, and we are such
a user.



  Kevin Closson replied: just out of curiosity, what is "real high" in terms
of connect count?



   And another (maybe irrelevant) point: when there is a mid-tier shared
connection pool, that can also act as a concentrator/multiplexer (eg I have
LoadRunner tested 2000 "users" executing a realistic high volume workload
with (iirc) only 100-200 real Oracle connections). Yes, I know 2000 is not
"real high" :) but you can scale out this approach.



  MTS and app server shared pool have different strengths and weaknesses
(for the benefit of the BAAG party - or just to stimulate more informed
replies - I'll refrain from proving my ignorance by guessing what they are
:-).



  Regards Nigel








  --
  Regards
  Zhu Chao
  www.cnoug.org

Other related posts: