Re: Oracle only utilising single processor

"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

1 You need to have the Enterprise Edition with the Parallel Execution Option aka Parallel Query Option
2 Parallel Server is definitely not the same as Parallel Query Option 3 You can distribute the query with parallel query, at the cost of multiple processes for one query.
As there is overhead associated with Parallel Query just setting 'any Oracle tuning' is not going to help
4 You -like almost all other posters - don't provide any specifics (you might be running Oracle standard, we don't know what you define as 'poor', we have no details of your configuration, of the job you are running, of the execution plan of the statement(s) affected. Basically the only thing you say is 'It doesn't work' With that little info you shouldn't expect to get any useful responses.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address