This field displays the sum of the intervals between time in seconds checkpoints for all processes. For example, if Process 1 checkpoints after 500 seconds, the time in seconds category is incremented by 500. If Process 2 checkpoints after 600 seconds, the time in seconds category is incremented by an additional 600. Statistics for the other two interval categories are displayed in the "interval: AIJ blks" and "interval: tx count" fields. If CHECKPOINT TIMED EVERY 600 SECONDS is specified with the SQL ALTER DATABASE statement, each process checkpoints every 10 minutes. 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 time interval, divide the total count for seconds interval by the total number of checkpoints. If the total count for the seconds field is 59,300 and the total number of checkpoints is 100, the average number of seconds between each time-triggered checkpoint is 593. 59,300 / 100 = 593 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: tx count" field explains how to determine the average interval for transaction checkpoints.