17.05 - File System: Data Block Prefetch 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

These columns identify File Segment Prefetch activities.

A prefetch is either a cylinder read operation or an individual block read operation. Either of these operations are generically called a prefetch.
Column Name Mode Description Data Type
FileAPtPres count Total number of append table or permanent journal table data block or cylinder index disk segments prefetched. FLOAT
FilePCiPres count Total number of permanent cylinder index disk segments prefetched. FLOAT
FilePDbPres count Total number of permanent data block disk segments prefetched. FLOAT
FileSCiPres count Total number of regular or restartable spool index disk segments prefetched. FLOAT
FileSDbPres count Total number of regular or restartable spool data block disk segments prefetched. FLOAT
FileTJtPres count Total number of transient journal table disk segments prefetched. FLOAT
FileAPtPresKB count Total number of KB prefetched by FileAPtPres. FLOAT
FilePCiPresKB count Total number of KB prefetched by FilePCiPres. FLOAT
FilePDbPresKB count Total number of KB prefetched by FilePDbPres. FLOAT
FileSCiPresKB count Total number of KB prefetched by FileSCiPres. FLOAT
FileSDbPresKB count Total number of KB prefetched by FileSDbPres. FLOAT
FileTJtPresKB count Total number of KB prefetched by FileTJtPres. FLOAT
FileAPtPreReads count Total number of append table or permanent journal table data block or cylinder index disk segment prefetches that caused a physical read. FLOAT
FilePCiPreReads count Total number of permanent cylinder index disk segment prefetches that caused a physical read. FLOAT
FilePDbPreReads count Total number of permanent data block disk segment prefetches that caused a physical read. FLOAT
FileSCiPreReads count Total number of regular or restartable spool index disk segment prefetches that caused a physical read. FLOAT
FileSDbPreReads count Total number of regular or restartable spool data block disk segment prefetches that caused a physical read. FLOAT
FileTJtPreReads count Total number of transient journal table disk segment prefetches that caused a physical read. FLOAT
FileAPtPreReadKB count Total number of KB physical read by FileAPtPreReads. FLOAT
FilePCiPreReadKB count Total number of KB physical read by FilePCiPreReads. FLOAT
FilePDbPreReadKB count Total number of KB physically read by FilePDbPreReads. FLOAT
FileSCiPreReadKB count Total number of KB physical read by FileSCiPreReads. FLOAT
FileSDbPreReadKB count Total number of KB physical read by FileSDbPreReads. FLOAT
FileTJtPreReadKB count Total number of KB physical read by FileTJtPreReads. FLOAT