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
Hi, initially after instaling 10g, I had problems and then
were solved deleting all statistics and gathering again for tables and
histograms and I didn't saw this problem again (maybe It is still there
but I didn't see it)
mccmx_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
Received on Fri Oct 13 2006 - 07:57:56 CDT