Displaying Log Area and Log Writer Information 
Displaying Log Area and Log Writer Information
Use
You are provided with information about the state and size of the
log area and the activities of the Log Writer.
Procedure
Choose Instance ® Information ® Log.
|
Log mode |
Mode in which the log is operated |
|
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 written |
Number of savepoints written since last log backup |
|
Checkpoints written |
Number of checkpoints written |
|
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 |
|
Queues allocated |
Current log queue allocation |
|
Queue entries |
Maximum size of the log queue |
|
Queue overflows |
Number of log queue overflows |
|
Group commits |
Number of group commits |
|
Waits for logwriter |
Number of wait states for log write operations |
|
Max. waits |
Maximum number of wait states per log page |
|
Avg. Waits |
Average number of wait states per 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) |