Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to identify when an index is rebuild?

User_X7R4DDec 2 2021

I need to find the dates when an index is rebuilt. Can I use the column last_ddl_time from dba_objects?
The last_ddl_time column description is as follows.
Timestamp for the last modification of the object resulting from a DDL statement (including grants and revokes)
Therefore, I assume that this last_ddl_time can be modified with several other factors. Accordingly, is there a way to find when an index is rebuilt? Or still, can I use this last_ddl_time for this?

Comments
Post Details
Added on Dec 2 2021
12 comments
7,155 views