Get more information from Oracle audit trail I just turned on auditing for an Oracle 11g database. I'm interested in getting more information about each event; for example, when I see a CREATE_INDEX event, I'd like to know which field was indexed. Is there any way to do that?
Sure, use one of the below settings:

AUDIT_TRAIL


  
  db, extended
  
  
  Performs all actions of AUDIT_TRAIL=db, and also populates the SQL
  bind and SQL text CLOB-type columns of the SYS.AUD$ table, when
  available. These two columns are populated only when this parameter is
  specified.
  
  
  xml, extended
  
  
  Performs all actions of AUDIT_TRAIL=xml, and includes SQL text and SQL
  bind information in the audit trail.


alter system set AUDIT_TRAIL=db, extended scope=spfile;
shutdown immediate
startup