MONITOR_PAGES
The <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_PAGES
monitor system table contains information about accesses to the pages.
Value |
Explanation |
|---|---|
|
Number of virtual read operations |
|
Number of virtual write operations |
|
Number of physical read operations |
|
Number of physical write operations |
|
Number of virtual catalog read operations |
|
Number of virtual catalog write operations |
|
Number of physical catalog read operations |
|
Number of physical catalog write operations |
|
Number of virtually read permanent pages |
|
Number of virtually written permanent pages |
|
Number of physically read permanent pages |
|
Number of physically written permanent pages |
|
Number of virtually read temporary pages |
|
Number of virtually written temporary pages |
|
Number of physically read temporary pages |
|
Number of physically written temporary pages |
|
Number of virtually read pages for LOB columns |
|
Number of virtually written pages for LOB columns |
|
Number of physically read pages for LOB columns |
|
Number of physically written pages for LOB columns |
|
Number of virtually read leaf pages |
|
Number of virtually written leaf pages |
|
Number of physically read leaf pages |
|
Number of physically written leaf pages |
|
Number of virtually read index pages at level 1 |
|
Number of virtually written index pages at level 1 |
|
Number of physically read index pages at level 1 |
|
Number of physically written index pages at level 1 |
|
Number of virtually read index pages at level 2 |
|
Number of virtually written index pages at level 2 |
|
Number of physically read index pages at level 2 |
|
Number of physically written index pages at level 2 |
|
Number of virtually read index pages at level 3 |
|
Number of virtually written index pages at level 3 |
|
Number of physically read index pages at level 3 |
|
Number of physically written index pages at level 3 |
|
Number of virtually read index pages at level 4 |
|
Number of virtually written index pages at level 4 |
|
Number of physically read index pages at level 4 |
|
Number of physically written index pages at level 4 |
|
Number of virtually read index pages at level 5 |
|
Number of virtually written index pages at level 5 |
|
Number of physically read index pages at level 5 |
|
Number of physically written index pages at level 5 |
|
Number of safeness checks on primary b* tree level one |
|
Number of successful safeness checks, i.e. the b* tree structure could be changed without locking the complete b* tree |
|
Always 0 |
|
Always 0 |
|
Number of physically read converter pages |
|
Number of physically written converter pages |
|
Number of clustered virtual reads |
|
Number of virtually read clustered pages |
|
Number of pages marked for resolving clusters |
|
Number of segments (with size DataIOClusterSize) read by cluster compression to free these segments. Equal to number of I/O calls made for cluster compression. |
|
Number of blocks read into temporary buffer (physical I/O) |
|
Number of pages relevant for cluster compression and set to status changed |