Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PARALLEL_AUTOMATIC_TUNING

Status
Not open for further replies.
sapatos

sapatos

Programmer
Jan 20, 2006
57
AU
my database has PARALLEL_AUTOMATIC_TUNING = TRUE and parallel_adaptive_multi_user = TRUE.

This means oracle decides how to process in parallel according to the literature.

I see that all the tables in my database have been created as NOPARALLEL. I assume this prevents oracle from making use of the above two parameter values.

On top of this parallel_max_servers = 48. Does this value therefore mean that only 48 parallel servers can run, thereby overriding the first two parameters above. If so, should the first two parameters be set to FALSE, and then make use of only the parallel_max_servers parameter?

I'm confused? ;)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top