Re: Oracle only utilising single processor

OPQ helps best with parallel ops, most strikingly, with full table scan type queries, where the table is striped physically across spindles.

The parallel option now helps also with loading from SQLLDR, assuming you go through the grief of chopping up your load data file and splitting it across spindles.

OP also helps with building and rebuilding indices, and of course has helped with system recovery and restart for a while (you can define in init.ora multiple servers to assist with all that tedious mess of reconstructing a database)

But you do have to have EE, and you do have to enable it. But I can say with some authority, that performance using PQ, raw I/O, striping across spindles, is unspeakably better in performance for full table scans, when there is no good way to index the thing.

RSH.
"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 Tue May 21 2002 - 14:59:43 CDT