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 -> Init. param. OPTIMIZER_PERCENT_PARALLEL > 0 ?

Init. param. OPTIMIZER_PERCENT_PARALLEL > 0 ?

From: Spendius <spendius_at_muchomail.com>
Date: 6 Nov 2003 07:33:27 -0800
Message-ID: <aba30b75.0311060733.1b500410@posting.google.com> 





Hi,


I'd just like to know whether you need to set the
OPTIMIZER_PERCENT_PARALLEL parameter to a value different
from its default (0) in order for the optimizer to take
the tables' degree of parallelism in account.



If yes, this OPTIMIZER_PERCENT_PARALLEL value can be set
between 0 and 100: but what are the meanings of figures
as different as 12, 44 or 87 ?!? Here again the Oracle
doc. is pretty obscure about the details.



Thanks a lot.


Regards,


Spendius
Received on Thu Nov 06 2003 - 09:33:27 CST












Original text of this message













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