You can display information on redo log management in the Database Manager GUI.
The database instance is in the operational state ONLINE.
Choose Instance ® Information ® Log Area.
Log writing |
ON:
Redo log management is activated. |
Log Automatic overwrite |
OFF:
Normal log backup operations |
Max. size |
Maximum available storage space in the log area |
Backup Segment size |
Size of a segment |
Used size (KB) |
Used space in KB |
Used size in % |
Used space as percentage |
Not saved (KB) |
Size of log area not yet saved, in KB |
Not saved (%) |
Size of log area not yet saved, as a percentage |
Log since last data backup (KB) |
Number of log pages written since the last data backup |
Savepoints |
Number of savepoints written since last log backup |
Physical reads |
Read activities in the log area since the last restart of the database system |
Physical writes |
Write activities in the log area since the last restart of the database system |
Queue size |
Current size of the log queue |
Queue overflows |
Number of log queue overflows |
Group commits |
Number of group commits |
Waits for logwriter |
Number of waits for log write operations |
Max. waits |
Maximum number of wait states for each log page |
Avg. Waits |
Average number of wait states for each log page |
OMS Log used |
Log area used by the Object Management System (OMS) |
OMS min. free pages |
Minimum number of free pages for the Object Management System (OMS) |
See also:
Changing Log Settings (Configuration Wizard)