The
general database parameter LOG_SEGMENT_SIZE denotes the size of a log segment in the log area in pages.For
interactive backups, the log segment size determines the size of the segments that the redo log entries are saved to. It also determines the intervals at which log areas are backed up automatically.The size of the log segment depends on the size of the individual
log volumes and must not be greater than the sum of all log volumes.|
User-defined value |
Log segment sizes used by the system |
|
No definition of log segment size (LOG_SEGMENT_SIZE = 0) |
A third of the total log area. |
|
The log segment size in pages is smaller than or the same as 50% of the title log area. |
The defined value for LOG_SEGMENT_SIZE. |
|
The log segment > 50% of the total log area. |
50% of the log area. |