Re: Oracle for Multi-Processor

Hi Andrew.

You need to install the Oracle Paralell Querry Option. Then you are able to manipulate querry's vai hints, or to ALTER TABLE ..... ( i don't remeber, but you find it in the Oracle docs).

To be able to paralize a querry, you have to do a full table scan, that is now using of index.

Hope this is of any help Andrew.

Best regards

Andrew Liu <andrew_at_pisces.taiwan.hp.com> wrote in article <70m2to$40$1_at_ocean.cup.hp.com>...
> Hi,
> Does Oracle need special patch or version to support multi-processor host
?
> I have a PC server running WindowsNT 4.0 with 4 CPU, and I have installed
> the Orcale server 7.3.3 on the host. The result is that Oracle would
utilize
> one of the CPU only, instead of the 4 CPUs. I monitored this situation on
> Task Manager. Why ? Will Parallel Query Server improve the situation ?
> How to build up the parallel query server for multi-processor machine ?
> Thanks!
>
>
>
>
Received on Thu Oct 22 1998 - 12:41:34 CDT