Re: Ora v7.1 to v7.3 speed problems (VMS)

We just upgraded from Oracle 7.1 to Oracle 7.3.2 on an very large Alpha server, the system performance is worst than before. From VMS system support group statistics, the same application now take 200 to 300% of CPU resource in Oracle 7.3.

Is there anyone else having the same problem.

Btw, we had logged a TAR for this with Oracle World Wide support. Regards, Barry
Shael Richmond ¼¶¼g©ó¤å³¹ <35CFA358.BF27D60F_at_bellsouth.net>...
>dean.batten_at_amcor.com.au wrote:
>>
>> Hi all,
>>
>> We're planning to upgrade our VMS v6.1/Ora v7.1 systems to VMS v7.1/Ora
v7.3.
>> We've set up a test platform with the target versions, but have
discovered
>> that it appears to run very slow compared to an identical machine running
the
>> older versions. I've heard rumors that Ora v7.3 does indeed run slower on
VMS
>> than Ora v7.1 - has anyone had experience with this upgrade that they'd
like
>> to share?
>>
>> As an example, starting sqlplus and logging into our database
>> ($ora_sqlplus:sqlplus usernam/passwd @) takes just 6 seconds on our
current
>> versions, but about 40 seconds on the test machine.
>>
>> I should note that all of this is happening on a pair of MicroVAX 3900's,
each
>> with 64MB of memory. I admit that they are old and slow, but why such a
big
>> difference between Oracle versions??
>>
>> I'm not a DBA by any stretch of the imagination - just the VMS system
manager
>> who's trying to establish whether he's stuffed up the config, or really
is
>> going to have to fork out for new hardware...
>>
>
>We saw the same thing on Alpha's, the login was much slower. Overall
>7.3.2
>was faster than 7.1.5, and 7.3.3.4 seemed better also.
>
>Shael
Received on Wed Aug 12 1998 - 10:52:49 CDT