Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Queries slower in 8.1.7.0 than in 8.1.6.2

Queries slower in 8.1.7.0 than in 8.1.6.2

From: dias <ydias_at_hotmail.com>
Date: 1 Feb 2002 06:54:21 -0800
Message-ID: <55a68b47.0202010654.ce4fc87@posting.google.com> 





Hi,



I've just upgrade a db from 8.1.6.2 to 8.1.7.0 on a Tru64 5.1a.
My application is a client-server one.



All the queries run 3 or seconds slower. 
With the explain plan, I've noticed that the optimizer uses more Hash
in the 8.1.7.0 version than in the 8.1.6.2.



Every thing is the same between the two versions : init.ora, disks,
machine, RAM, ...



Have I to apply the latest patch set to correct the problem.



Thank you
Received on Fri Feb 01 2002 - 08:54:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US