Oracle only utilising single processor

From: Justin Richardson <justin.richardson_at_redmar.com>
Date: 19 May 2002 07:10:56 -0700
Message-ID: <a24c4b48.0205190610.72fbb6e3@posting.google.com>

We are evaluating various configurations to improve performance on an Oracle Server. Using a Sun V880, with 8 processors, 32GB memory and Oracle 8.1.7.

Spread the tables over various spindles so there is little or no IO queues.

However performance is still poor as the benchmark/job we have to test is only using a single processor. The other 7 do relatively little, with one processor maxed out for the 2 hour test.

Is there any Oracle tuning that can spread the load?

Would Parallel Query Server help? If so how can I tell if this is configured or installed? Any recommendations for configuring/tuning the database for PQS?

Many thanks Received on Sun May 19 2002 - 09:10:56 CDT