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

In article <6qsdl2$pbj$1_at_imsp009a.netvigator.com>,   "Barry Lau" <barrylau_at_poboxes.com> wrote:
> 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
>
>

Hi,

We had the same problems on UNIX. It was due to a bug in oracle 7.3.2. Oracle TRACE is enabled by default, so performance ( especially during connect ) are very slow.

Check in $ORACLE_HOME/otrace/admin the size of the files regid.dat and process.dat, then run the command otrcref, this will decrease the size of the ORACLE trace files. Normally after running otrcref performance will be better.

Maybe you have the same pbm ON VMS than on UNIX.

Patrick.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 02:20:43 CDT