Database DataWarehousing (MOSC)

MOSC Banner

How DEGREE is calculated in dbms_stats job internally ?

edited Oct 2, 2012 8:33PM in Database DataWarehousing (MOSC) 4 commentsAnswered
 Hi All,

Can anybody help me to understand how the DOP is calculated for individual objects gather stats ?

I have already been through below and all available documents on degree of dbms_stas:

Degree of parallelism. The default for degree is NULL. The default value can be changed using the SET_PARAM Procedure.
NULL means use the table default value specified by the DEGREE clause in the CREATE TABLE or ALTER TABLE statement.
Use the constant DBMS_STATS.DEFAULT_DEGREE to specify the default value based on the initialization parameters.
The AUTO_DEGREE value determines the degree of parallelism automatically.

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