Object documentationMONITOR_PAGES Locate this document in the navigation structure

 

The <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_PAGES monitor system table contains information about accesses to the pages.

Structure

MONITOR_PAGES, DESCRIPTION Column

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

Level1 page safeness applied

Number of safeness checks on primary b* tree level one

Level1 page safeness approved

Number of successful safeness checks, i.e. the b* tree structure could be changed without locking the complete b* tree

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

Clustered virtual reads

Number of clustered virtual reads

Clustered page virtual reads

Number of virtually read clustered pages

Pages marked for reclustering

Number of pages marked for resolving clusters

Cluster compression segment reads

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.

Cluster compression block reads

Number of blocks read into temporary buffer (physical I/O)

Cluster compression pages handled

Number of pages relevant for cluster compression and set to status changed

More Information

MONITOR