I never change the statistics gathering, but instead chang the more
crazy settings;
optimizer_feature_enable to 9.2.0 or 8.1.7

can try at session level...

regards
ujang

On 7/14/07, Alexander Fatkulin <afatkulin@(protected):
> yep
>
> The standard job tries to be "one size fits all"... It's the lowest
> common denominator. Works bad for one and horribly for the others
> (it's an exaggeration, but so... :)
>
> On 7/13/07, Joe Armstrong-Champ <joseph.armstrong-champ@(protected):
>
> >
> > Has anyone else has experienced this sort of thing in their environments?
> >
> > Joe
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
--
http://www.freelists.org/webpage/oracle-l