FreeLists / oracle-l / Re: Analyze not working properly in 7.3.4

[Jared Still <jkstill@xxxxxxxxx>]

There is a bug mentioned in the 8.1.7 release notes.
According to the notes the bug manifests itself when analyzing
indexes only - bug number 1161906

"last_analyzed column in the view *_tables is filled with a corrupt date 
when only an index is ana The problem occurs because the date field is not 
set when CREATE INDEX ... COMPUTE STATISTICS is used.

Jared


On 5/2/05, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> wrote:
> 
> I dimly remember (after all, this release is over 10 years old!)=20
> that, due to a bug, LAST_ANALYZED didn't get updated as it should. If
> the statistics are OK, and your SQL is performing acceptably, that's
> probably what's happening here.
> 
> --=20
> Paul Baumgartel
> paul.baumgartel@xxxxxxxxx
> 
> On 5/2/05, Smith, Ron L. <rlsmith@xxxxxxx> wrote:
> > I run an Analyze estimate on all my tables and indexes every 
> weekend.=3D2=
> 0
> > But for some reason the LAST ANALYZED column of USER_TAB_COLUMNS as well
> > as LAST ANALYZED in USER TABLES=3D20
> > indicates that the tables and indexes have not been analyzed in a year.
> > The statistics on each object appear to be correct.
> --
> http://www.freelists.org/webpage/oracle-l
> 



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l