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

Home -> Community -> Usenet -> c.d.o.tools -> Parallel servers on normal queries

Parallel servers on normal queries

From: Great Oracle <greatoracle_at_yahoo.com>
Date: Sat, 16 Dec 2000 22:14:24 +0800
Message-ID: <91ft68$ejl$1@dahlia.singnet.com.sg> 






Will it help if I have a 4CPU server, 2GB ram, NT 4.0 and enable the
parallel_max_server=100 and parallel_min_server=80 whereas all of the tables
queries are not programmed with parallel query option?



Any other parameters that can help my oracle db to speed up apart from
rearranging the hardware? I have thrown in MTS, big big SGA, shared_pool,
log buffer, db_block_buffers etc. Thanks in advance.
CK
Received on Sat Dec 16 2000 - 08:14:24 CST












Original text of this message













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