content_image/712712.jpg
<img src='content_image/712712.jpg'>

• FLUSH_TYPE 

The flush type. 

• FIX_COUNT 

The number of threads using this block within the buffer pool. When zero, the block is eligible to be evicted. 

• IS_HASHED 

Whether a hash index has been built on this page. 

• NEWEST_MODIFICATION 

The Log Sequence Number of the youngest modification. 

• OLDEST_MODIFICATION 

The Log Sequence Number of the oldest modification. 

• ACCESS_TIME 

An abstract number used to judge the first access time of the page. 

• TABLE_NAME 

The name of the table the page belongs to. This column is applicable only to pages with a PAGE_TYPE value of INDEX . The column is NULL  if the server has not yet accessed the table. 

• INDEX_NAME 

The name of the index the page belongs to. This can be the name of a clustered index or a secondary index. This column is applicable only to pages with a PAGE_TYPE  value of INDEX . 

• NUMBER_RECORDS 

The number of records within the page. 

• DATA_SIZE 

The sum of the sizes of the records. This column is applicable only to pages with a PAGE_TYPE  value of INDEX . 

