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

mccmx_at_hotmail.com wrote:
> > 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?
> >
>
> I asked Oracle to publish this BUG and this is their response.....
>
> "Yes, currently Oracle Development has this bug marked as unpublished
> as they are still investigating. I have just updated the bug to reflect
> your case.
>
> I will provide you Development's update to me per my update to bug
> 5557078 on your behalf. Until then, I'm going to make the status of
> this SR = DEV identifiying this bug, 5557078."
>
> That's as clear as mud then....!
>
> Matt

Team:
Having seen this thread, I seem to be seeing same issue. Many of my tables did not get analyzed for long time, so I ran following script manually;

declare
begin
sys.dbms_stats.gather_schema_stats(ownname=>'SAPPHIRE', cascade=>TRUE); end;
/

I then verified every table and index was analyzed by looking at last_analyzed column.

But when I ran some queries and looked in Oracle 10g sql tuning advisor, it still said
statistics for some tables as stale. Why? Does above statement still go thorugh oracle 10g bug? Received on Fri Oct 20 2006 - 08:41:11 CDT