Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Parallel servers on normal queries
It might slow things down; it depends. What is slow, why, and much are very important questions. Just throwing software and hardware at the problem does not ensure you will get a positive result. For example, you don't mention your drive configuration. Drive configuration (how many, what type of striping -RAID 5, 0+1, a single disk) determines throughput. This may be the limiting factor by far. Also what are the queries? Are you using bind variables, what version of Oracle, have you analyzed your tables and indexes, what is the explain plan on the longest running queries. You need more information before a reasonable solution can be proposed. Jim
"Great Oracle" <greatoracle_at_yahoo.com> wrote in message
news:91ft68$ejl$1_at_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 - 09:21:48 CST