Tagged Questions

2
votes
1answer
2k views

In Oracle, if parallel_max_servers is set to be significantly less than the DOP can the explain plan be sub-optimal?

For tables that have DEGREE DEFAULT, the degree of parallelism (DOP) is calculated by Oracle using number of CPUs and number of threads per CPU amongst other things. As I understand it, when costing ...