Re: Performance hit after Upgrade from Oracle 7.1 to t.3

If you are running cost based did you update the object statistics? With version 7.3 direct sorts are the default and hash joins come into play. Both have related init.ora parameters that may need adjustment. When we went from 7.2.3 to 7.3.3 under Unix we had about four jobs start running slow. Each of them had switched to hash joins. We hinted these four jobs are the rest of the system was pretty much fine.

We have researched upgrading our VMS 6.1 Oracle 7.1.5 system to VMS 7.1 Oracle 7.3 but have not done so yet. Still it seems there was some problems related to sqlnet published with the early versions. You might want to check to see if maybe there are some sqlnet parameters that need setting or changing rather than a patch.

Other than the above have you ran your basic monitoring scripts like buffer cache ratio, library catch ratio, latch hit ratio etc... to make sure no database resource bottleneck has developed that is compounding the slow sqlnet connection time? Just a thought to help verify that the problem is directly related to sqlnet and only sqlnet.

ketanindia_at_hotmail.com wrote in article <6n0ou0$k9j$1_at_nnrp1.dejanews.com>...
> Hi, We recently upgraded from Oracle7.1.5 on VMS6.2 to Oracle7.3.2.3.2 on
Vms
> 7.1 (Alpha OpenVMS) The sqlplus connections are very slow. This can be
> explained by the 2 task products. But the performance after the
connection is
> very very poor. For example if I select from a table of 300000 rows it
takes
> 10 minutes to give 4000 rows which in the earlier version used to give me
all
> the rows in 30 minutes. I really can't figure out why this is happening.
Can
> somebody out there give me any clues ? Will MTS help ? If yes then what
are
> the things I need to to before setting that up ? Do I have to tweak
init.ora
> parameters. I really did not change anything after upgrade. Will Fast I/O
of
> VMS help ? I tried browsing this group but nobody seemed to have this
> problem. People have done upgrade and have been satisfied it seems.
>
> My machine isa single processor alpha with 1.2G memory and 40G disk space
out
> of which oracle has 8-10 G at its disposal.
>
> Thanks in advance.
>
> Ketan Shah
> Mellon Bond Associates, Pittsburgh
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Mon Jun 29 1998 - 10:00:41 CDT