Init parameterSecurity & auditing
AUDIT_FILE_DEST
What it controls
Directory for OS audit files, including SYS audit records.
Know this before you change it
This directory fills up quietly. Clean it on a schedule.
Check and change it
1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'audit_file_dest';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'audit_file_dest' AND isspecified = 'TRUE';8 9-- Applies to sessions that connect after the change10ALTER SYSTEM SET audit_file_dest = '/u01/app/oracle/admin/ORCL/adump' DEFERRED SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET audit_file_dest SCOPE = SPFILE SID = '*';Open in the parameter referenceOracle's reference
More in Security & auditing
- AUDIT_TRAILWhere traditional auditing records go.
- AUDIT_SYS_OPERATIONSAudits top-level statements run as SYS, SYSDBA and SYSOPER to OS files.
- REMOTE_LOGIN_PASSWORDFILEWhether a password file is used for remote SYSDBA connections.
- SEC_MAX_FAILED_LOGIN_ATTEMPTSFailed attempts on one connection before the server drops it.