Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sort latch usage in MTS mode

Re: sort latch usage in MTS mode

From: Nigel Thomas <nigel_cl_thomas_at_yahoo.com>
Date: Mon, 6 Aug 2007 11:10:56 -0700 (PDT)
Message-ID: <360443.48463.qm@web58705.mail.re1.yahoo.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 06 2007 - 13:10:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US