Re: Warning: Built in 10g Stats gather is broken

From: Evan <eehrenh_at_emory.edu>
Date: Thu, 12 Oct 2006 13:35:54 -0400
Message-ID: <452E7CFA.4040007@emory.edu>

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
>

I looked for the bug and did not find it.

I used "advance search", put in the bug number 5557078. No hits.

Is the number correct?

Thanks Received on Thu Oct 12 2006 - 12:35:54 CDT