Home | Previous Page | Next Page   Logging and Log Administration > Managing the Physical Log > Monitoring Physical and Logical Logging Activity >

Using SMI Tables

Query the sysprofile table to obtain statistics on the physical-log and logical-log buffers. The following rows contain the relevant 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
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]