| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: When was an index last rebuilt?
This is a multi-part message in MIME format.
--------------5356903DF493468BFD711A7A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
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.
>
> Regards,
> Bruce Reardon
>
--------------5356903DF493468BFD711A7A
Content-Type: text/x-vcard; charset=us-ascii;
name="cdyke.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Casey Dyke Content-Disposition: attachment;
begin:vcard
n:Dyke;Casey
tel;pager:(022) 9436 9290 tel;home:61 2 9948 1487 tel;work:61 2 9005 1073
url:www.realsurf.com org:Excite_at_Home Australia;IT-Ops adr:;;100 Harris Street;Pyrmont;NSW;2042;Australiaversion:2.1
 |
 |