The <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_PAGES monitor system table contains information about accesses to the pages.
Value |
Explanation |
---|---|
Virtual reads |
Number of virtual read operations |
Virtual writes |
Number of virtual write operations |
Physical reads |
Number of physical read operations |
Physical writes |
Number of physical write operations |
Catalog virtual read |
Number of virtual catalog read operations |
Catalog virtual writes |
Number of virtual catalog write operations |
Catalog physical reads |
Number of physical catalog read operations |
Catalog physical writes |
Number of physical catalog write operations |
Perm page virtual reads |
Number of virtually read permanent pages |
Perm page virtual writes |
Number of virtually written permanent pages |
Perm page physical reads |
Number of physically read permanent pages |
Perm page physical writes |
Number of physically written permanent pages |
Temp page virtual reads |
Number of virtually read temporary pages |
Temp page virtual writes |
Number of virtually written temporary pages |
Temp page physical reads |
Number of physically read temporary pages |
Temp page physical writes |
Number of physically written temporary pages |
LOB page virtual reads |
Number of virtually read pages for LOB columns |
LOB page virtual writes |
Number of virtually written pages for LOB columns |
LOB page physical reads |
Number of physically read pages for LOB columns |
LOB page physical writes |
Number of physically written pages for LOB columns |
Leaf page virtual reads |
Number of virtually read leaf pages |
Leaf page virtual writes |
Number of virtually written leaf pages |
Leaf page physical reads |
Number of physically read leaf pages |
Leaf page physical writes |
Number of physically written leaf pages |
Level1 page virtual reads |
Number of virtually read index pages at level 1 |
Level1 page virtual writes |
Number of virtually written index pages at level 1 |
Level1 page physical reads |
Number of physically read index pages at level 1 |
Level1 page physical writes |
Number of physically written index pages at level 1 |
Level2 page virtual reads |
Number of virtually read index pages at level 2 |
Level2 page virtual writes |
Number of virtually written index pages at level 2 |
Level2 page physical reads |
Number of physically read index pages at level 2 |
Level2 page physical writes |
Number of physically written index pages at level 2 |
Level3 page virtual reads |
Number of virtually read index pages at level 3 |
Level3 page virtual writes |
Number of virtually written index pages at level 3 |
Level3 page physical reads |
Number of physically read index pages at level 3 |
Level3 page physical writes |
Number of physically written index pages at level 3 |
Level4 page virtual reads |
Number of virtually read index pages at level 4 |
Level4 page virtual writes |
Number of virtually written index pages at level 4 |
Level4 page physical reads |
Number of physically read index pages at level 4 |
Level4 page physical writes |
Number of physically written index pages at level 4 |
Level5 page virtual reads |
Number of virtually read index pages at level 5 |
Level5 page virtual writes |
Number of virtually written index pages at level 5 |
Level5 page physical reads |
Number of physically read index pages at level 5 |
Level5 page physical writes |
Number of physically written index pages at level 5 |
Converter page virtual reads |
Always 0 |
Converter page virtual writes |
Always 0 |
Converter page physical reads |
Number of physically read converter pages |
Converter page physical writes |
Number of physically written converter pages |