Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Warning: Built in 10g Stats gather is broken
On Oct 12, 4:06 am, m..._at_hotmail.com wrote:
> It looks as though Oracle's built in Stats gather process doesn't work.
>
> The table change information that should be written to
> USER_TAB_MODIFICATIONS isn't being updated correctly. So when the
> nightly job comes along to analyze the tables, it will miss some tables
> because they don't appear in this view. Beware.
>
> Check out Bug 5557078 on Metalink.
>
> It has been filed against 10.1 but we are having the same problem on
> 10.2.
>
> How the hell did this test this functionality....!
>
> Matt
Thank you for the bug post as you never know when you will run into these things.