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 -> Re: USING COST BASED OPTIMISATION ON A MULTI-PROCESSOR,MULTI-DISK DRIVE SERVER

Re: USING COST BASED OPTIMISATION ON A MULTI-PROCESSOR,MULTI-DISK DRIVE SERVER

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 18 Mar 1999 22:24:48 -0000
Message-ID: <921796288.10891.0.nnrp-09.9e984b29@news.demon.co.uk> 





It might use a sort_merge too, though, and that could be even worse.



--



Jonathan Lewis


Yet another Oracle-related web site: www.jlcomp.demon.co.uk



Sylvain Leclerc wrote in message


<044CD796C702D111B56800608CCC51D00D4944_at_INT_04>...


>You may just try to shut the hash join down by






>HASH_JOIN_ENABLED = OFF






>in your initsid.ora.  The CBO wil use nested loops instead of hash


>joins.





Received on Thu Mar 18 1999 - 16:24:48 CST












Original text of this message













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