AUDIT_TRAIL

Property	Description
Parameter type	String
Syntax	AUDIT_TRAIL = { none | os | db | db_extended | xml | xml, extended }
Default value	db
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 SQLTEXT CLOB 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.

Note:

1. The OS option is not supported on all platforms. When it is supported output is sent to the location specified by .

The values TRUE and FALSE are also supported for backward compatibility. TRUE is equivalent to DB. FALSE is equivalent to NONE.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = 'AUDIT_TRAIL';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
audit_trail	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	enable system auditing

Oracle initializatoin parameters