-
-
-
SQL> SHOW PARAMETER AUDIT
NAME TYPE VALUE
----------------------------------------------------
audit_file_dest string C:\ORACLE\PRODUCT\10.2.0\
ADMIN\DB10G\ADUMP
audit_sys_operations boolean FALSE
audit_trail string NONE
SQL>Audit is disable by default, but can be enabled by audit_trail
static parameter which can have following possible values.