Re: Oracle 7.2.3 & MTS

Craig Harper <caharper_at_hooked.net> wrote:

>Robert F. Owens, Jr. wrote:
>>
>> I am currently running Oracle 7.2.3 on a Solaris 2.5 Sun Sprac 1000 with
>> MTS and SQL*Net 2.x. We are having performance problems. Has anyone had
>> problems with MTS and and Oracle 7.2.3. It has difficult to determine
>> exactly where the problem resides because it just appears at random times
>> during the day.
 

>Robert,
 

>I am running MTS on HP/UX 10.10 it is working well for us. Connection
>time has improved. Oracle, however, suggested that we not run MTS. It
>was their feeling that MTS was more headache than it was worth.

How "old" is this information ?

I have met a number of people, including oracle employees, who were not able to do a mts-setup. But if you go through the "headache", your database will benefit:

• you have more memory available (which can be used for database buffers), because you need fewer shadow-processes
• response time may decrease, because no additional oracle-processes are created when someone connects to the database

>--
 

>Craig Harper
>IFTN
>(v) 415.583.4528
>(f) 415.583.5536

Willy Klotz

Willys Mail     FidoNet   2:2474/117  2:2474/118  
                Mailbox: analog 06297 910104
                         ISDN   06297 910105
                Internet: 0629791010_at_t-online.de                
                ->   No Request from 06.00 to 08.00 <-
======================================================================