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 execution plans Oracle will assume the default DOP for tables with
At execution time, however, if
parallel_max_servers is less than the default DOP then the number of parallel servers will be restricted and - I presume - the final execution may not go as intended by the costed execution plan and a less parallel execution plan may be preferable.
Is this correct?