SMI tables

Query the sysprofile table to obtain statistics on the physical-log and logical-log buffers. The sysprofile table also provides the same checkpoint statistics that are available from the onstat -p option. These rows contain the following statistics.
plgpagewrites
Number of pages written to the physical-log buffer
plgwrites
Number of writes from the physical-log buffer to the physical log file
llgrecs
Number of records written to the logical-log buffer
llgpagewrites
Number of pages written to the logical-log buffer
llgwrites
Number of writes from the logical-log buffer to the logical-log files
numckpts
Number of checkpoints that have occurred since the database server was brought online)
ckptwaits
Number of times that threads waited for a checkpoint to finish entering a critical section during a checkpoint
value
Values for numckpts and ckptwaits

Copyright© 2019 HCL Technologies Limited