syscheckpoint

The syscheckpoint table provides information and statistics about checkpoints.

Column Type Description
interval integer Number of checkpoints since the server was started
type char(12) Hard or Interval
caller char(10) Caller of the checkpoint
clock_time integer Time of day the checkpoint occurred
crit_time float Time spent waiting for the critical section to be released
flush_time float Time spent flushing pages to disk
cp_time float Duration from checkpoint pending until checkpoint done
n_dirty_buffs integer Number of dirty buffers
plogs_per_sec integer Number of physical log pages processed in a second
llogs_per_sec integer Number of logical log pages processed in a second
dskflush_per_sec integer Number of buffer pool pages flushed in a second
ckpt_logid integer Unique id of the logical log at the checkpoint
ckpt_logpos integer Position of the logical log at the checkpoint
physused integer Number of pages used in the physical log
logused integer Number of pages used in the logical log
n_crit_waits integer Number of users who had to wait to enter a critical section
tot_crit_wait float Duration spent waiting for all users waiting at the checkpoint critical section block
longest_crit_wait float Longest critical section wait
block_time float Duration of the checkpoint that blocked the system

Copyright© 2019 HCL Technologies Limited