Hi Howard,
I really really appreciate your help on my question.
I understand WHEN should I use MTS now.
For the "LARGE_POOL_SIZE", what should I set to.
CUrrently, my SGA is around 100 Meg.
Dominica
"
Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<3d546e38_at_dnews.tpgi.com.au>...
> "Dominica Leung" <dominica_l_at_yahoo.com> wrote in message
> news:5f8af180.0208091526.69a763c_at_posting.google.com...
> > Hi Sybrand,
> >
> > One more thing,
> > I need to increase the SGA area right , if I would be RUNNING
> > MTS in my server.
>
> When you configure MTS, you should configure a LARGE_POOL_SIZE. When you do
> that, the SHARED_POOL_SIZE doesn't need to increase significantly.
>
> As ever, though, it's a question of tuning: monitor the shared pool and see
> if can benefit from a modest increase.
>
> > Basically, I am not too sure, what other oracle parameters
> > I should be changing/tuning when change to MTS version.
>
> There aren't many, apart from the obvious MTS_ ones. LARGE_POOL_SIZE is the
> only one that readily springs to mind.
>
> Regards
> HJR
>
> > This part really worry me.
> > Since I NEVER run MTS in my whole career in the production
> > environment and this production environment is very sensitive.
> >
> >
> >
> > Dominica
> >
> > =======
> >
> > S
> > ybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> news:<ld38luggqm8dd6ou4imt2bss7rp78un291_at_4ax.com>...
> > > On 9 Aug 2002 11:37:16 -0700, dominica_l_at_yahoo.com (Dominica Leung)
> > > wrote:
> > >
> > > >Sorry, one question, the mts_dispatchers should be
> > > >listenering on its own port right?
> > > >Not the same as the LISTENER.
> > >
> > > Hi Dominica,
> > > not necessarily. You can always set up an extra tnsnames.ora entry
> > > with (server=dedicated) added. When you look at lsnrctl services, you
> > > will see you get 2 different services, whether using 2 different ports
> > > or not.
> > >
> > > Hth
> > >
> > >
> > > Sybrand Bakker, Senior Oracle DBA
> > >
> > > To reply remove -verwijderdit from my e-mail address
Received on Mon Aug 12 2002 - 15:32:01 CDT
