Re: Degree of parallelism for dbms_stats

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

(As with any parallel operation) if the degree is too high, you end up thrashing on some sort of resource shortfall - typically being one or more of:

• insufficient cpu to service the slaves
• insufficient IO bandwidth (or IO contention) for the slaves
• excessive messaging between the slaves

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."