Jump to Navigation

301 - AUDIT_TRAIL, AUDIT_FILE_DEST

You can check AUDIT_TRAIL parameter as the following. If it is "OS", audit information is stored in the AUDIT_FILE_DEST.

SQL> show parameters AUDIT_TRAIL

SQL> show parameters AUDIT_FILE_DEST

 

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 SQLTEXT CLOB columns of the SYS.AUD$ table.
xml Enables database auditing and writes all audit records to XML format OS files.
xml, extended xml,extended - Enables database auditing and prints all columns of the audit trail, including SqlText
    and SqlBind values.

* IF AUDIT_TRAIL = os, Check the number of files at the following.

/u01/app/oracle/admin/mydb/adump> ls -lrt *aud | wc -l
58375

 

 



Main menu 2

Story | by Dr. Radut