17.05 - Memory: Page Faults Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
Column Name Mode Description Data Type
PageMajorFaults count Number of major page faults.

If the page is not loaded in memory at the time the fault is generated, then it is called a major or hard page fault.

FLOAT
PageMinorFaults count Number of minor page faults.

If the page is loaded in memory at the time the fault is generated, but is not marked in the memory management unit as being loaded in memory, then it is called a minor or soft page fault.

FLOAT