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 -> Problem with optimizer of Oracle 8.0.4 & .5 Server on NT

Problem with optimizer of Oracle 8.0.4 & .5 Server on NT

From: Tomas Mraz <tomm_at_NOkamaradSPAM.cz>
Date: Thu, 7 Oct 1999 14:34:49 +0200
Message-ID: <7ti419$1u4c$1@mail1.pvt.net> 





Hello there,


I have a problem with runnig queries on table when using complex AND/OR
expression


in the WHERE clause. When I try to run this query the Oracle process which
serves this query hangs. When I try to explain plan for the same query it
hangs too. I think it's some error in the
SQL optimizer.


Has anyone simmilar experiences? Some help?
I've tried insert a /*+rule*/ hint into the SQL statement, but it didn't
change anything.



Tom Mraz




Received on Thu Oct 07 1999 - 07:34:49 CDT












Original text of this message













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