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

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 12 Oct 2006 10:38:07 -0700
Message-ID: <1160674687.770251.220840@i42g2000cwa.googlegroups.com>

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....!
>

Thanks Matt but I don't find that bug when I search. Is this something submitted from your environment/company?

If so, could you please request that it be opened up so that other people can check it out? Or give me some other keywords to search on and find other relevant ( if any ) info in metalink?

Thanks John Received on Thu Oct 12 2006 - 12:38:07 CDT