MONITOR_PAGES

Definition

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

Structure

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

LONG page virtual reads

Number of virtually read pages for LONG columns

LONG page virtual writes

Number of virtually written pages for LONG columns

LONG page physical reads

Number of physically read pages for LONG columns

LONG page physical writes

Number of physically written pages for LONG 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

See also:

MONITOR