Home -> Usenet -> comp.databases.oracle -> Performace problem after upgraded from 8.0.5 to 8.1.7

Performace problem after upgraded from 8.0.5 to 8.1.7

From: Sam <hinfun_at_hotmail.com>
Date: 27 Mar 2002 05:29:28 -0800
Message-ID: <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 - 14:29:28 CET












Original text of this message