ORACLE initialization parameter: AUDIT_TRAIL

ORACLE initialization parameter: AUDIT_TRAIL initialization parameter AUDIT_TRAIL is used to control database audit. The default value is none. Parameter type: String default value: none allow dynamic modification: no basic parameter: No Syntax:

AUDIT_TRAIL = {none | OS | db, extended | xml, extended}

 

Detailed description of parameters: AUDIT_TRAIL enables or disables database audit. When this parameter is set to NONE or FALSE, database audit is prohibited. When this parameter is set to OS, database audit is activated and audit records are written to the OS audit trail file; when this parameter is set to DB or TRUE, database audit is activated and audit records are written to the data dictionary SYS. AUD $; when this parameter is set to DB_EXTENDED, not only audit records are written to the data dictionary SYS. in AUD $, The SQLBIND and SQLTEXT columns of the data dictionary are also filled. Value description: none disables Database Audit OS enables database audit, directs database audit records to the operating system audit records db enables database audit, and directs all database audit records to the database's SYS. AUD $ table db, extended enables database audit, and directs all audit records of the database to the database's SYS. AUD $ table. In addition, fill in the SQLBIND column and sqltext clob column of the SYS. AUD $ table. Enable Database Audit in xml and write all records to operating system files in XML format. Xml, extended enables database Audit and outputs all columns of audit records, including SqlText and SqlBind values. You can use the SQL statement AUDIT to set AUDIT options, regardless of how this parameter is set. Example: Because the initialization parameter is a static parameter, you must restart the routine after modification. Example:

SQL> alter system set audit_trail = db scope = SPFILE; SQL> STARTUP FORCE;