Re: Degree of parallelism for dbms_stats

DOP = At most 2* cpu_count parameter is the default according to http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server. 817/a76994/tuningpe.htm

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

YES!!!! I have seen boxes running Oracle that are also highly loaded NFS servers where if I remember the NFSd runs at the kernel level and gets priority (under Solaris anyways). Front end applications running on the same server can be a CPU killer. There was one helpdesk system that I will not name that used to have a front end process peg the CPU for no identified reason. It had to be killed. This of course dragged DB performance down to a complete and utter crawl.....

Regards,
Kyle
www.gadgets.co.nz

"zongk Tu" <jpseo_at_yahoo.com> wrote in message news:3CA13904.76676C49_at_yahoo.com...
> 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
>
>
Received on Wed Mar 27 2002 - 22:23:19 CST