Viewing Page and I/O Status |
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: