2.10 ALERT_LOG_MAX_SIZE

ALERT_LOG_MAX_SIZE specifies the maximum size of the alert log (in bytes).

Property	Description
Parameter type	Big integer
Syntax	ALERT_LOG_MAX_SIZE = integer [K | M | G]
Default value	1000M
Modifiable	ALTER SYSTEM
Modifiable in a PDB	No
Range of values	0, 50 MB to operating system-dependent
Basic	No
Oracle RAC	Multiple instances can have different values.

Space for the alert log is allocated in segments of 50 MB each. Therefore, the default value of 1000 MB for this parameter indicates that the maximum alert log size is 20 segments, each with a size of 50 MB.

If you set this parameter to value that is not a multiple of 50 MB, the effective maximum alert log size will be the next higher multiple of 50 MB. For example, the following statement specifies a maximum alert log size of 120 MB. However, it will result in an effective maximum alert log size of 150 MB (3 segments of 50 MB):

ALTER SYSTEM SET ALERT_LOG_MAX_SIZE = 120M;

Setting this parameter to 0 specifies that there can be an unlimited number of 50 MB XML alert log segments, while the alert text log file consists of a single segment that can grow to an unlimited size.

If you specify a value less than 50 MB (other than 0), an error will occur.

Note:

This parameter is available starting with Oracle Database 23ai, Release Update 23.9.