17.05 - File System: Segments Acquired 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 the total disk memory segments acquired by the File System during the log period.

The File XXxAcqs columns are the only columns counted as cache hits, where XXx represents one of the following entries:
  • APt
  • PCi
  • PDb
  • SCi
  • SDb
  • TJt
Column Name Mode Description Data Type
FileAPtAcqs count Total number of append table or permanent journal table data block or cylinder index disk segments. FLOAT
FilePCiAcqs count Total number of permanent cylinder index disk segments acquires that were logically acquired. FLOAT
FilePDbAcqs count Total number of permanent data block disk segments acquires that were logically acquired. FLOAT
FileSCiAcqs count Total number of regular or restartable spool cylinder index disk segments acquires that were logically acquired. FLOAT
FileSDbAcqs count Total number of regular or restartable spool data block disk segments acquires that were logically acquired. FLOAT
FileTJtAcqs count Total number of transient journal or WAL data block or WAL cylinder index disk segments acquires that were logically acquired. FLOAT
FileAPtAcqKB count Total KB logically acquired by FileAPtAcqs. FLOAT
FilePCiAcqKB count Total KB logically acquired by FilePCiAcqs. FLOAT
FilePDbAcqKB count Total KB logically acquired by FilePDbAcqs. FLOAT
FileSCiAcqKB count Total KB logically acquired by FileSCiAcqs. FLOAT
FileSDbAcqKB count Total KB logically acquired by FileSDbAcqs. FLOAT
FileTJtAcqKB count Total KB logically acquired by FileTJtAcqs. FLOAT
FileAPtAcqReads count Number of append table or permanent journal table data block or cylinder index disk segment acquires that caused a physical read. FLOAT
FilePCiAcqReads count Number of permanent cylinder index disk segment acquires that caused a physical read. FLOAT
FilePDbAcqReads count Number of permanent data block disk segment acquires that caused a physical read. FLOAT
FileSCiAcqReads count Number of regular or restartable spool cylinder index disk segment acquires that caused a physical read. FLOAT
FileSDbAcqReads count Number of regular or restartable spool data block disk segment acquires that caused a physical read. FLOAT
FileTJtAcqReads count Number of transient journal or WAL data block or WAL cylinder index disk segment acquires that caused a physical read. FLOAT
FileAPtAcqReadKB count Total KB physically read by FileAPtAcqReads. FLOAT
FilePCiAcqReadKB count Total KB physically read by FilePCiAcqReads. FLOAT
FilePDbAcqReadKB count Total KB physically read by FilePDbAcqReads. FLOAT
FileSCiAcqReadKB count Total KB physically read by FileSCiAcqReads. FLOAT
FileSDbAcqReadKB count Total KB physically read by FileSDbAcqReads. FLOAT
FileTJtAcqReadKB count Total KB physically read by FileTJtAcqReads. FLOAT
FileAPtAcqsOther count Total number of append table or permanent journal table data block or cylinder index scratch disk segments that were logically acquired. FLOAT
FilePCiAcqsOther count Total number of permanent cylinder index scratch disk segments that were logically acquired. FLOAT
FilePDbAcqsOther count Total number of permanent data block scratch disk segments that were logically acquired. FLOAT
FileSCiAcqsOther count Total number of regular or restartable spool cylinder index scratch disk segments that were logically acquired. FLOAT
FileSDbAcqsOther count Total number of regular or restartable spool data block scratch disk segments that were logically acquired. FLOAT
FileTJtAcqsOther count Total number of transient journal or WAL data block or WAL cylinder index scratch disk segments that were logically acquired. FLOAT
FileAPtAcqOtherKB count Total number of append table or permanent journal table data block or cylinder index scratch disk segments acquired in KB. FLOAT
FilePCiAcqOtherKB count Total number of permanent cylinder index scratch disk segments acquired in KB. FLOAT
FilePDbAcqOtherKB count Total number of permanent data block scratch disk segments acquired in KB. FLOAT
FileSCiAcqOtherKB count Total number of regular or restartable spool cylinder index scratch disk segments acquired in KB. FLOAT
FileSDbAcqOtherKB count Total number of regular or restartable spool data block scratch disk segments acquired in KB. FLOAT
FileTJtAcqOtherKB count Total number of transient journal or WAL data block or WAL cylinder index scratch disk segments acquired in KB. FLOAT