max_syslog_file_count

Description

max_syslog_file_count specifies the maximum number of log files that can be retained before they are recycled.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can use the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view to query this parameter.

• Modify the parameter

  Only the sys tenant can modify this parameter. User tenants cannot modify this parameter.

Attributes

Considerations

• The total number of log files of all types cannot exceed max_syslog_file_count. Log files are recycled based on the FIFO (First In, First Out) strategy. The FIFO strategy selects the log file based on the last modification time of the log file. For example, the log files xxxxxxxx.log.20231123223441234 are sorted based on their end time to determine the order of recycling.

• The file retention rule is as follows: the total number of rotated xxxxxx.log.xxxxx files cannot exceed max_syslog_file_count, and the total number of rotated xxxxxx.log.wf.xxxxx files cannot exceed max_syslog_file_count. Note that the active log files (such as observer.log and rootservice.log) being written to and their corresponding WF files are not counted in this limit.

• If trace logs are generated too quickly and in large quantities, they may occupy the disk space of OBServer log files, leading to the early recycling of OBServer logs. In this case, we recommend that you adjust the trace log level to determine the appropriate log volume. For more information about trace log levels, see Trace log levels.

• The relationship between the max_syslog_file_count parameter and the syslog_disk_size parameter is as follows:

  1. max_syslog_file_count=0 and syslog_disk_size=0: indicates that logs are not recycled until the disk is full.
  2. max_syslog_file_count=0 and syslog_disk_size>0: when the total size of logs approaches syslog_disk_size, the oldest log files are deleted to recycle space.
  3. max_syslog_file_count>0 and syslog_disk_size=0: when the number of a type of log file exceeds max_syslog_file_count, the oldest log files are deleted to recycle space.
  4. max_syslog_file_count>0 and syslog_disk_size>0: when the number of a type of log file exceeds max_syslog_file_count or when the total size of logs approaches syslog_disk_size, the oldest compressed files are deleted to recycle space.

Examples

Set the maximum number of log files that can be retained before they are recycled to 20.

obclient> ALTER SYSTEM SET max_syslog_file_count=20;

References

• Logs
• Log control methods