Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parallel query not working

936749Jan 24 2013 — edited Jan 24 2013

Hi,
We're trying to configure Parallel server to AUTO and have configured the following:

parallel_degree_policy=AUTO
parallel_min_time_threshold=DEFAULT
parallel_degree_limit = CPU
parallel_server_target = Default
parallel_max_servers = 285

ALTER SYSTEM SET parallel_degree_policy = "AUTO" SCOPE=MEMORY
ALTER SYSTEM SET parallel_degree_policy = "AUTO" SCOPE=SPFILE

Still the database does not run any queries in parallel although some of the queries run for several hours.
Have we forgotten a parameter to get this to work?

We've removed hints from the queries and parallel degree on the tables.
Need help...
Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2013

Added on Jan 24 2013

#11g, #database, #general-database-discussions, #performance

8 comments

423 views