Is it a single job? If so then unless you are using parallel query it will
mainly be on a processor. It depends what the benchmark does whether
parallel query is useful or not. Is it one statement or interaction with a
client?
Jim
"Justin Richardson" <justin.richardson_at_redmar.com> wrote in message
news:a24c4b48.0205190610.72fbb6e3_at_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 - 11:20:55 CDT
