Re: Oracle 8.0.6.2 MTS configuration..need help?

Hi Sybrand,

Thank you.
I am very curious about what you think about MTS. Since I really VALUE your opinion. (I know you know a lot of in Oracle). Basically, my small machine E420 R , 4 CPU, 4Gig of memory .
Has 2000 processes and currently has 970 processes on NON-MTS(dedicated server) , and the unix 's "TOP" has very high load, and now my upper management at work, is thinking about going to MTS. But today, I was talking to tech support to Oracle about Net8. They says MTS is quite slow , I am running oracle 8.0.6.2.

And then my upper management also was thinking about connection manager... to have more connection pools. I have NOT read about connection manager yet.

But not sure whether going MTS route will actually help out the HEAVY LOAD performance in this machine. This machine has 532 'select " per second.

Dominica

Sybrand 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 - 18:17:03 CDT