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 |
|
| 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 AI Database 26ai, Release Update 23.9.