The space for partial and complete checkpoints is calculated as follows:
- 32 statements per second translates to 1920 statements per minute.
- 1920 / 20 (the packing factor) = 93 partial checkpoints/minute
- Multiply by 15 (15 minute CP frequency) = 1395 partial checkpoint rows maximum.
- Each checkpoint row is 117 + (12 * 20) = 357 bytes so 498,015 bytes are in partial checkpoint rows.
- Given that the load takes just more than an hour, assume 5 checkpoints are written at 300 bytes each.
Now the grand total of space in the log table is: 2,400 + 498,015 + 1,500 = 517,980 bytes.