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 -> 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