How to get index last modified time in Oracle? Given an index name, I want to obtain its last modification time and the author of modification in Oracle 11g. Is there any query to achieve this?
I will elaborate on the @Jeffrey Kemp's comment. Since the information about authors of modifications is not collected in the objects' metadata, you will want to use database auditing mechanisms.

As per Verifying Security Access with Auditing chapter of Database Security Guide, there are several types of auditing, but Standard Auditing is probably the only type of auditing you will need according to the requirements you mentioned in the question.

Before you can use standard auditing, you should enable it (if it already isn't) setting the AUDIT_TRAIL initialization parameter to the appropriate value (refer to the link). I evaluated standard auditing with AUDIT_TRAIL set to DB,EXTENDED which allows to capture SQL statements.

SQL&gt; alter system set audit_trail = db,extended scope=spfile;
System altered.

SQL&gt; startup force;
ORACLE instance started.


Once you have enabled standard auditing, all the auditing policies existing in your database will start to capture the auditing details.

There are four levels in standard auditing: Statement, Privilege, Object, Network. (See the table in the same chapter of Security Guide.)

With the following standard auditing statements of different levels I was able to collect some useful auditing information regarding index creation, index rebuild, index drop, and making index unusable.

audit index by access;    
audit create any index;    
audit index on hr.employees by access;


Sample output based on my activity is below.

SQL&gt; select username, sql_text from dba_audit_object order by timestamp;

USERNAME          SQL_TEXT
--------          ------------------------------------------------------
hr                create index audidx on employees(last_name)
hr                alter index audidx rebuild
scott             drop index hr.audidx
scott             create index hr.audidx on hr.employees(last_name)
scott             alter index hr.audidx rebuild
scott             alter index hr.audidx unusable


Make sure you understand what's written in the relevant chapter of Security Guide I referred to, and do some experiments before using your newly implemented audit policies in production.

For the other types of auditing and useful information regarding auditing check my previous answers.