Checkpoint tracing information from onstat -g ckp ckp_list| column | description
| | rownum | sequence number of checkpoint in output | | class | status monitor setting based on checkpoint time | | interval | checkpoint interval id | | clock_time | time checkpoint occurred | | trigger | what triggered the checkpoint | | lsn | logical log position of checkpoint | | total_time | checkpoint duration in secods | | flush_time | time to flush buffer pools | | block_time | transaction blocking time | | num_waits | number of transactions that waited | | ckpt_time | time from checkpoint request to start | | wait_time | average time transactions waited | | long_time | longest time a transaction waited | | num_dirty | number of dirty buffers flushed during the checkpoint | | disk_flush_sec | number of pages flushed per second | | phys_log_pages | number of pages physically logged during checkpoint interval | | phys_log_avg_sec | average physical log pages per second | | logical_log_pages | total number of logical log pages during checkpoint interval | | logical_log_avg_sec | number of logical log pages per second |
summary values| column | description | | ckp_total | Total number of checkpoints | | checkpoint_status | Status based on config.ini checkpoint_alert settings |
|