Re: How to make Oracle use all CPUs on SUN

On 26 Oct 2002 10:22:45 -0700, dmx_frank_at_yahoo.com (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.

It seems Oracle only use one
CPU to process all queries.

This definitely isn't true, just run the top command and you will see you are wrong.

Jim Kennedy recommended Parallel Query to you. However Parallel Query is difficult to tame and isn't really useful if you don't have at least as much as physical disks and controllers as you have processors.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Oct 26 2002 - 15:20:11 CDT