Enabling Audit Trail in oracle database 11g

AUDIT_TRAIL

Property	Description
Parameter type	String
Syntax	AUDIT_TRAIL = { none | os | db [, extended] | xml [, extended] }
Default value	none
Modifiable	No
Basic	No

AUDIT_TRAIL enables or disables database auditing.

Values:

• none
  Disables database auditing.
• os
  Enables database auditing and directs all audit records to the operating system's audit trail.
• db
  Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table).
• db, extended
  Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table). In addition, populates the SQLBIND and SQLTEXTCLOB columns of the SYS.AUD$ table.
• xml
  Enables database auditing and writes all audit records to XML format OS files.
• xml, extended
  Enables database auditing and prints all columns of the audit trail, including SqlText and SqlBind values.

You can use the SQL AUDIT statement to set auditing options regardless of the setting of this parameter.