Re: Oracle 8.0.6.2 MTS configuration..need help?

"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 Fri Aug 09 2002 - 20:37:45 CDT