What is the Max Parallel server Process spawned when using default degree of Parallelism
Hi All,
Good days, I have some doubt how oracle determine the Max number of parallel process when PARALLEL clause is specified but no degree of parallelism is listed?
In our environment, we don't use "DEGREE" in any app table and index. The parallel only trigger in "gather stat" command.
We're using "dbms_stats.auto_degree", what is the max parallel server process will be spawned for this statement? Any formula we can
estimate the max number of parallel processes?
Gather stat syntax:
dbms_stats.gather_table_stats('HR', 'EMPLOYEE', estimate_percent => 100, degree => dbms_stats.auto_degree, method_opt => 'for all columns size auto', cascade => TRUE);
0