This
monitor system table contains information on the logging operations (writing log information) performed by the database system.DESCRIPTION column
|
Value |
Explanation |
|
Log page physical reads |
Number of physically read log pages |
|
Log page physical writes |
Number of physically written log pages |
|
Log queue pages |
Size of the log queue in pages |
|
Log queue max used pages |
Maximum number of used log queue pages |
|
Log queue inserts |
Number of insert operations in the log queue |
|
Log queue overflows |
Number of log queue overflows |
|
Log queue group commits |
Number of group COMMITs |
|
Log queue waits for log page write |
Number of waiting times for log write operations |
|
Log queue max waits per log page |
Maximum number of waiting times per log page |
|
Log queue avg waits per log page |
Average number of waiting times per log page |