Using 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.

Row

Description

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 to enter a critical section during a checkpoint

value

Values for numckpts and ckptwaits