Re: Performace problem after upgraded from 8.0.5 to 8.1.7
Date: Wed, 27 Mar 2002 22:21:51 GMT
Message-ID: <3Cro8.27847$8%1.10716797_at_typhoon.nyroc.rr.com>
Sam,
Details of the query in question and DDL (schema description)
would be helpful, along with some indication of the volume of
data involved.
Regards... Jon
Jon Armstrong (Java, C, C++, Oracle, MySQL and much more)
[ 24/7 Solutions - Any problem, on any platform, any time. ]
"Sam" <hinfun_at_hotmail.com> wrote in message
news:e53193a9.0203270529.ccce008_at_posting.google.com...
> I have a performance problem that used to be 40 sec now comes to 90
> sec after upgraded to 8i. Generally i have 1 table that outer join to
> other four tables that is giving the performance penalty and i have
> noded that transferring of rows from server to client is slower on
> 8.1.7
>
> The hardware platforms is the same except I hv allocated lots of
> memory to 8i and still plenty for the OS (NT 4 SP6).
>
> Is there any tricks in tunning up the server ?
>
> Thanks
>
> Sam
Received on Wed Mar 27 2002 - 23:21:51 CET