Re: How to make Oracle use all CPUs on SUN

The default is to use all cpu's. Check parameter cpu_count, sql> show parameter cpu ;
If count is 4 then check all paramerters, show parameter; Then hit the docs on parallel query. /Svend

Frank Y wrote:

> Hi all,
>
> Background information:
> SUNFire 450 server with 4 CPUs,2GB RAM
> Solaris 2.8
> Oracle 8.1.7 with typical installation.
>
> I have a query join on four table with a lot of extenal procedure
> calls (some computational work for each row of data).
> When I execute this query, the first CPU will be 100% used, and other
> user's query will be 4 times slower than before. But other CPUs
> remain very low(below 10 %) utilization. It seems Oracle only use one
> CPU to process all queries.
>
> I wonder how can make Oracle use all 4 CPUs resource. Is there any
> configuration in Oracle must be set? Or any thing can be done at OS
> level?
>
> Thanks very much!
>
> Frank.
>
Received on Sat Oct 26 2002 - 18:03:03 CDT