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 -> Newbie: How to ensure parallel query execution

Newbie: How to ensure parallel query execution

From: DSmith <dsmith2005_at_yahoo.com>
Date: Thu, 28 Jan 1999 18:15:12 -0500
Message-ID: <36b199ae.0@208.206.112.5> 





All,



I have an Oracle 8.0.4 instance on an NT box w/4 CPUs and 1 GB of RAM.  Do I
simply add the parameters:


parallel_max_servers, parallel_min_servers, sort_area_size, hash_area_size,
and optimizer_percent_parallel to the initxxxx.ora file to ensure parallel
query execution?



The manual is pretty clear on how to determine the appropriate values but
how does one test the functionality?  Any help would be greatly appreciated.



David Smith


dsmith_at_hpti.com




Received on Thu Jan 28 1999 - 17:15:12 CST












Original text of this message













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