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

From: <mccmx_at_hotmail.com>
Date: 20 Oct 2006 08:20:38 -0700
Message-ID: <1161357638.338328.293010@i42g2000cwa.googlegroups.com>

> 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?

It sounds like they may be related problems. I would also log a TAR with Oracle. We are currently using a workaround to flush the stats to the user_tab_mod table.

Matt Received on Fri Oct 20 2006 - 10:20:38 CDT