Overview

This document provides information on the types, properties, syntax, and configuration methods of parameters related to log files.

Method

ACT_LOG_DEST

This parameter sets the directory where the activity log file is stored.
The details of the ACT_LOG_DEST parameter are as follows.

ACT_LOG_FILE_SIZE

This parameter sets the maximum size of the activity log file.
The details of the ACT_LOG_FILE_SIZE parameter are as follows.

AUDIT_FILE_DEST

This parameter sets the directory where the Audit TRAIL file is stored; the location must be set as an absolute path.
The details of the AUDIT_FILE_DEST parameter are as follows.

AUDIT_FILE_SIZE

This parameter sets the maximum size of the Audit TRAIL file.
If a single log file exceeds the value set in the AUDIT_FILE_SIZE parameter, the current log file is backed up and a new file is created.
The details of the AUDIT_FILE_SIZE parameter are as follows.

AUDIT_LOG_TOTAL_SIZE_LIMIT

This parameter sets the maximum total size of Audit TRAIL files stored in the directory specified by the AUDIT_FILE_DEST parameter.
The reason for setting the AUDIT_LOG_TOTAL_SIZE_LIMIT parameter is that if Audit TRAIL log files are created beyond the set value, the oldest Audit TRAIL log file will be deleted and the log storage space will be reused to prevent unlimited creation of Audit TRAIL log files.
The details of the AUDIT_LOG_TOTAL_SIZE_LIMIT parameter are as follows.

CALLSTACK_DUMP_DEST

This parameter sets the directory where the Callstack Dump file is stored; the location must be set as an absolute path.
The details of the CALLSTACK_DUMP_DEST parameter are as follows.

CM_LOG_DEST

This parameter sets the directory where the TBCM log file is stored; the location must be set as an absolute path.
The details of the CM_LOG_DEST parameter are as follows.

CM_LOG_FILE_SIZE

This parameter sets the maximum size of the TBCM log file.
If a single TBCM log file exceeds the size defined in the CM_LOG_FILE_SIZE parameter, the current TBCM log file is backed up and a new TBCM log file is created.
The details of the CM_LOG_FILE_SIZE parameter are as follows.

CM_LOG_TOTAL_SIZE_LIMIT

This parameter sets the maximum total size of TBCM log files stored in the directory specified by the CM_LOG_DEST parameter247"The reason for setting the CM_LOG_TOTAL_SIZE_LIMIT parameter is that if TBCM log files are created beyond the set value, the oldest TBCM log file will be deleted and the log storage space will be reused to prevent unlimited creation of TBCM log files.
The details of the CM_LOG_TOTAL_SIZE_LIMIT parameter are as follows.

DBMS_LOG_DEST

This parameter sets the directory where the Database log file is stored; the location must be set as an absolute path.
The details of the DBMS_LOG_DEST parameter are as follows.

DBMS_LOG_FILE_SIZE

This parameter sets the maximum size of the Database log file.
If a single database log file exceeds the size defined in the DBMS_LOG_FILE_SIZE parameter, the current database log file is backed up and a new database log file is created.
The details of the DBMS_LOG_FILE_SIZE parameter are as follows.

DBMS_LOG_TOTAL_SIZE_LIMIT

This parameter sets the maximum total size of Database log files stored in the directory specified by the DBMS_LOG_DEST parameter.
The reason for setting the DBMS_LOG_TOTAL_SIZE_LIMIT parameter is that if Database log files are created beyond the set value, the oldest Database log file will be deleted and the log storage space will be reused to prevent unlimited creation of Database log files.
The details of the DBMS_LOG_TOTAL_SIZE_LIMIT parameter are as follows.

ILOG_DEST

This parameter sets the directory where the Internal log file is stored; the location must be set as an absolute path.
The details of the ILOG_DEST parameter are as follows.

ILOG_FILE_SIZE

This parameter sets the maximum size of the Internal log file.
If a single Internal log file exceeds the size defined in the ILOG_FILE_SIZE parameter, the current Internal log file is backed up and a new Internal log file is created.
The details of the ILOG_FILE_SIZE parameter are as follows.

ILOG_TOTAL_SIZE_LIMIT

This parameter sets the maximum total size of Internal log files stored in the directory specified by the ILOG_DEST parameter.
The reason for setting the ILOG_TOTAL_SIZE_LIMIT parameter is that if Internal log files are created beyond the set value, the oldest Internal log file will be deleted and the storage space will be reused to prevent unlimited creation of Internal log files.
The details of the ILOG_TOTAL_SIZE_LIMIT parameter are as follows.

LOG_DEFAULT_DEST

This parameter sets the directory where the server log file is stored; the location must be set as an absolute path.
The details of the LOG_DEFAULT_DEST parameter are as follows.

LSNR_LOG_DEST

This parameter sets log file is stored; the location must be set as an absolute path.
The details of the LSNR_LOG_DEST parameter are as follows.

LSNR_LOG_FILE_SIZE

This parameter sets the maximum size of the Listener log file.
If a single Listener log file exceeds the size defined in the LSNR_LOG_FILE_SIZE parameter, the current Listener log file is backed up and a new Listener log file is created.
The details of the LSNR_LOG_FILE_SIZE parameter are as follows.

LSNR_LOG_TOTAL_SIZE_LIMIT

This parameter sets the maximum total size of Listener log files stored in the directory specified by the LSNR_LOG_DEST parameter.
The reason for setting the LSNR_LOG_TOTAL_SIZE_LIMIT parameter is that if Listener log files are created beyond the set value, the oldest Listener log file will be deleted and the storage space will be reused to prevent unlimited creation of Listener log files.
The details of the LSNR_LOG_TOTAL_SIZE_LIMIT parameter are as follows.

MEM_LOG_DEST

This parameter sets the directory where the Memory log file is stored; the location must be set as an absolute path.
The details of the MEM_LOG_DEST parameter are as follows.

SLOG_DEST

This parameter sets the directory where the System log file is stored; the location must be set as an absolute path.
The details of the SLOG_DEST parameter are as follows.

SLOG_FILE_SIZE

This parameter sets the maximum size of the System log file.
If a single System log file exceeds the size defined in the SLOG_FILE_SIZE parameter, the current System log file is backed up and a new System log file is created.
The details of the SLOG_FILE_SIZE parameter are as follows.

SLOG_TOTAL_SIZE_LIMIT

This parameter sets the maximum total size of System log files stored in the directory specified by the SLOG_DEST parameter.
The reason for setting the SLOG_TOTAL_SIZE_LIMIT parameter is that if System log files are created beyond the set value, the oldest System log file will be deleted and the storage space will be reused to prevent unlimited creation of System log files.
The details of the SLOG_TOTAL_SIZE_LIMIT parameter are as follows.

SQL_TRACE_DEST

This parameter sets the directory where the SQL Trace log file is stored; the location must be set as an absolute path.
The details of the SQL_TRACE_DEST parameter are as follows.

TRACE_DUMP_DEST

This parameter sets the directory where the Trace Dump file is stored set as an absolute path.
The details of the TRACE_DUMP_DEST parameter are as follows.