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