Re: sort latch usage in MTS mode
- From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
- To: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
- Date: Wed, 8 Aug 2007 16:49:49 +0800
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:
