Re: Multi-processor in Oracle8 database server under Windows NT

The answer to 1) is NO. Parallel Server is for clusters. The answer to 2) is generally no, because Oracle will determine the values for these parameters at database creation based on the environment parameters, one of which is the number of processors. In real life, two processors doesn't really lend itself to that sort of tuning anyway, as there are still other Oracle background processes and NT services which are also running, and only certain types of queries can make use of parallel execution. My experience (having a dual PPro server) is that system response is better for many users, but queries for the most part don't seem faster.

Andy Johnson

Ronald Wong wrote:

> Hi,
>
> We are going to install an Oracle8 database server under NT in a single
> multi-processor computer system (Dual Pentium II). Would someone kindly to
> answer the following questions that are related to Oracle8 in a
> multi-processor system?
>
> 1) Do I have to use Oracle Parallel Server so as to enable parallel
> execution in the computer?
> 2) Are there any system parameters in the Oracle8 server that are related to
> multi-processor? Or what I have to do is to tune the system parameters such
> as OPTIMIZER_PERCENT_PARALLEL, PARALLEL_MAX_SERVERS, etc... according to the
> manual?
>
> Many thanks!
>
> Ronald
Received on Sat Jul 18 1998 - 23:45:34 CDT