Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 7938 invoked from network); 8 Aug 2007 04:32:28 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2007 04:32:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 088E0724B31; Wed, 8 Aug 2007 05:30:10 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05756-07; Wed, 8 Aug 2007 05:30:09 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72FB0724436; Wed, 8 Aug 2007 05:30:09 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 08 Aug 2007 04:47:34 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3EEB972261C for ; Wed, 8 Aug 2007 04:47:34 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26483-04 for ; Wed, 8 Aug 2007 04:47:34 -0400 (EDT) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D42D37220EA for ; Wed, 8 Aug 2007 04:47:32 -0400 (EDT) Received: by an-out-0708.google.com with SMTP id b36so31923ana for ; Wed, 08 Aug 2007 01:49:50 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=TaDRgFJbEuCGtAzUGLSBKlUNehuzdrr1xOxhf3UxuBLN6ut//U1Zr2tqg4mcfo+DBJS0fp+xOjZp8x6k9erxILr+EYHILz8yDLkaVkp0SDoONV74ZfTKnUX9syuCIl++DaYywILb8XDVMBtVGHnX3JlQltss7gqk3hOse0Yd4+I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=XHoI+spitiSdObCIUw/g1ancO/8iWubYvA4tlEr+DL+TDEpwazXVz9HA97HUum4FfH6fR7xlZzQavrnii72oeC4qEje48XYSmMJIF9rcTZR5bGtfkC0ZG4tQV4kx8OnkPRrrrmgTk8ZhJ+7LghT27uN/EnA/tahgyXnBf03sw7M= Received: by 10.100.9.19 with SMTP id 19mr1182897ani.1186562989467; Wed, 08 Aug 2007 01:49:49 -0700 (PDT) Received: by 10.100.154.7 with HTTP; Wed, 8 Aug 2007 01:49:49 -0700 (PDT) Message-ID: <962cf44b0708080149o1d05e033i7cc253e8f308ec15@mail.gmail.com> Date: Wed, 8 Aug 2007 16:49:49 +0800 From: "Zhu,Chao" To: "Rajeev Prabhakar" Subject: Re: sort latch usage in MTS mode Cc: oracle-l In-Reply-To: <2ba656800708061215n1d612ebey5a4d63174c61ee00@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_154657_19501736.1186562989427" References: <360443.48463.qm@web58705.mail.re1.yahoo.com> <2ba656800708061215n1d612ebey5a4d63174c61ee00@mail.gmail.com> X-archive-position: 405 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-to: zhuchao@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_154657_19501736.1186562989427 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 ------=_Part_154657_19501736.1186562989427 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_154657_19501736.1186562989427-- -- http://www.freelists.org/webpage/oracle-l