DEBUG_LOG_MAX_SIZE
DEBUG_LOG_MAX_SIZE specifies the maximum size of the debug 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 debug log is allocated in segments of 50 MB each. Therefore, the default value of 1000 MB for this parameter indicates that the maximum debug 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 debug log size will be the next higher multiple of 50 MB. For example, the following statement specifies a maximum debug log size of 120 MB. However, it will result in an effective maximum debug log size of 150 MB (3 segments of 50 MB):
ALTER SYSTEM SET DEBUG_LOG_MAX_SIZE = 120M;Setting this parameter to 0 specifies that there can be an unlimited number of 50 MB XML debug log segments, while the debug 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.