Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_STATS.GATHER_SYSTEM_STATS
Well there are some nice underscore parameters to keep up with it if you
delve into X$KSPPI
and if you look at DBMS_XPLAN you can see some CPU stuff.
and if you look at a 10053 trace you can see CPU influences everywhere. I might try and do a breakover test to see where a cpu difference actually affects it.
"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message
news:atca9c$bn3$1_at_news.mch.sbs.de...
> Hi,
>
> anybody with experience with this new feature out there?
>
> I'm interested in bugs, influence on optimizer, general experience.
>
> Regards
> Stephan
>
>
Received on Fri Dec 13 2002 - 06:07:41 CST