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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Ted Coyle
Sent: Wednesday, August 08, 2007 6:28 AM
To: zhuchao@gmail.com; '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@freelists.org [mailto:oracle-l-bounce@freelists.org] 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?

 

On 8/7/07, Rajeev Prabhakar < rprabha01@gmail.com> 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@yahoo.com > 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