Database DataWarehousing (MOSC)

MOSC Banner

What is the Max Parallel server Process spawned when using default degree of Parallelism

edited Oct 3, 2013 12:04AM in Database DataWarehousing (MOSC) 6 commentsAnswered
  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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center