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

On Fri, 26 Jun 1998 18:22:57 GMT, ketanindia_at_hotmail.com <ketanindia_at_hotmail.com> wrote:
>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.

I saw at least one case where it was apparently DECNET's fault. Replacing with any other vendors TCP made things ten times faster. Sorry I can't give more details as I'm not on VMS anymore.

>
>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

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Jun 26 1998 - 17:58:26 CDT