Re: Degree of parallelism for dbms_stats

Gilles;

I believe the degree of parallelism defaults to the cpu= parameter in the init.ora...

If you are on Unix platform, the recommended value is 2x # of cpu's...

Of course, this all depends on what else is running on the box besides Oracle...

HTH

--
Zongk Tu

Oracle Apps DBA/Unix SA

Gilles Florentin wrote:



> Hi all,

>

> Anybody knowd a formula to compute the optimal degree of parallelism

> for DBMS_STATS package ?

>

> And what could be the impact of having an oversized degree ?

>

> Thanks for all your answers.

>

> Gilles


--
Zongk Tu

Oracle Apps DBA/Unix SA