This field displays the sum of the intervals between checkpoints due to the transactions count checkpoint for all processes. For example, if Process 1 checkpoints after 20 transactions, the transactions count category is incremented by 20. If Process 2 checkpoints after 30 transactions, the transactions count category is incremented by an additional 30. Statistics for the other two interval categories are displayed in the "interval: AIJ blks" and "interval: seconds" fields. The transactions limit for checkpoints is determined by the setting of the RDM$BIND_CKPT_TRANS_INTERVAL logical name. If RDM$BIND_CKPT_TRANS_INTERVAL is defined as a system logical set to 10, each process will checkpoint after 10 transactions unless a user redefines the RDM$BIND_CKPT_TRANS_INTERVAL logical to a different value. That is, if a user defines RDM$BIND_CKPT_TRANS_ INTERVAL as a process logical and sets a value of 5, that user will checkpoint after 5 transactions. Keep in mind that checkpointing influences recovery time. The main reason to consult checkpoint statistics is to find the average interval per checkpoint. You can use the information in the total count column to compute this average. For each category of checkpoint reason, use the average interval per checkpoint to help you decide if a checkpointing interval should be adjusted, and by how much. If most of the checkpoints for a database are triggered by a particular checkpoint limit, that limit may be set too high, or the other two limits may be set too low. You can determine the average interval per checkpoint for each type of checkpoint limit. After you have this information, you can reset the limits so that each type of checkpoint limit triggers approximately the same number of checkpoints, which results in optimal performance. To compute the average transactions interval, divide the total count for transaction intervals by the total number of checkpoints. If the total count for transaction intervals is 800 and the total number of checkpoints is 100, then the average number of transactions between checkpoints is 8. 800 / 100 = 8 The help for the "interval: AIJ blks" field explains how to determine the average interval for .aij file growth checkpoints. The help for the "interval: seconds" field explains how to determine the average interval for time checkpoints.