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:
- 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