Viewing Page and I/O Status

How To

The page and I/O status page displays operating system statistics from the SYSINFO table. Page and I/O status items and their corresponding SYSINFO.INFO values are summarized in Table.

Page and I/O Status Items

Description

Number of Index Page Splits Occurring

The accumulated number of index pages split in the current run time. (NUM_IDX_SPLIT)

Number of Data Pages Compressed

The accumulated number of data pages reorganized in the current run time. (NUM_PAGE_COMPRESS)

Number of Physical Reads

The accumulated page number of page/frame disk reads in the current run time. (NUM_PHYSICAL_READ)

Number of Physical Writes

The accumulated number of page/frame disk writes in the current run time. (NUM_PHYSICAL_WRITE)

Number of Logical Reads

The accumulated page number of logical reads (reading data from page buffer cache) in the current run time. (NUM_LOGICAL_READ)

Number of Logical Writes

The accumulated number of logical writes (writing data into page buffer cache) in the current run time. (NUM_LOGICAL_WRITE)

Number of Page Buffers

The number of page buffers currently used by the database. (NUM_PAGE_BUF)

Table: Page and I/O Status items


Related topic:

Monitoring Database Status