ckp_list

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