RE: When was an index last rebuilt?

That would be moot point..

-----Original Message-----
From: Casey Dyke [mailto:cdyke_at_excitehome.com.au] Sent: January 02, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L Subject: Re: When was an index last rebuilt?

Perhaps a mute point to note that a number of other operations could update the column and mask an index rebuild. If DDL is quiet other than index rebuilds, then monitoring this column may prove satisfactory. Have a vague recollection that grants and the like can modify this column - emphasis on vague. Would be interesting to know exactly which events do talk to this column though. Perhaps an API for all index rebuilds that logs its work could
be a solution?

:0)

> Hi,
>
> As of 8.1.5 this information is not stored in any of timestamp,
> last_ddl_time nor the created field.
>
> However, this is a bug (1096399) and rebuilding an index should update
> last_ddl_time - see excerpt below from a Metalink forum:
>
> "
>
> Hi. ALTER INDEX ... REBUILD does not update DBA_OBEJCTS.LAST_DDL_TIME in
> Oracle7/8. This is documented in bug 1096399. This bug is fixed in 8.1.7
> where an ALTER INDEX ... REBUILD of a non-partitioned index will update
the
> LAST_DDL_TIME column of DBA/USER/ALL_OBJECTS.
> "
>
> The bug details state that the data_object_id field does get updated in
> versions below 817, so if really needed then perhaps this field could be
> used as a flag to indicate index rebuilds.
Received on Tue Jan 02 2001 - 21:07:12 CST