How to make Oracle use all CPUs on SUN

From: Frank Y <dmx_frank_at_yahoo.com>
Date: 26 Oct 2002 10:22:45 -0700
Message-ID: <9d599275.0210260922.5d75721c@posting.google.com>

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 - 12:22:45 CDT