These columns identify the total disk memory segments acquired by the File System during the log period. Logical acquires (Acqs) and the logical amount acquired (AcqKB) are identified. Acquires causing physical reads (AcqReads) and the amount read (AcqReadKB) are identified as a subset of logical acquires.
Column Name | Mode | Description | Data Type |
---|---|---|---|
FileAPtAcqs | count | Total number of append table or permanent journal table data block or cylinder index disk segments acquired. | FLOAT |
FilePCiAcqs | count | Total number of permanent cylinder index disk segments acquired. | FLOAT |
FilePDbAcqs | count | Total number of permanent data block disk segments acquired. | FLOAT |
FileSCiAcqs | count | Total number of regular or restartable spool index disk segments acquired. | FLOAT |
FileSDbAcqs | count | Total number of regular or restartable spool data block disk segments acquired. | FLOAT |
FileTJtAcqs | count | Total number of transient journal table disk segments acquired. | FLOAT |
FileAPtAcqKB | count | Total KB acquired by FileAPtAcqs. | FLOAT |
FilePCiAcqKB | count | Total KB acquired by FilePCiAcqs. | FLOAT |
FilePDbAcqKB | count | Total KB acquired by FilePDbAcqs. | FLOAT |
FileSCiAcqKB | count | Total KB acquired by FileSCiAcqs. | FLOAT |
FileSDbAcqKB | count | Total KB acquired by FileSDbAcqs. | FLOAT |
FileTJtAcqKB | count | Total KB acquired by FileTJtAcqs. | FLOAT |
FileAPtAcqReads | count | Number of append table or permanent journal table data block or cylinder index disk segments 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 index disk segments that caused a physical read. | FLOAT |
FileSDbAcqReads | count | Number of regular or restartable spool data block disk segments that caused a physical read. | FLOAT |
FileTJtAcqReads | count | Number of transient journal table disk segments that caused a physical read. | FLOAT |
FileAPtAcqReadKB | count | KB physically read by FileAPtAcqReads. | FLOAT |
FilePCiAcqReadKB | count | KB physically read by FilePCiAcqReads. | FLOAT |
FilePDbAcqReadKB | count | KB physically read by FilePDbAcqReads. | FLOAT |
FileSCiAcqReadKB | count | KB physically read by FileSCiAcqReads. | FLOAT |
FileSDbAcqReadKB | count | KB physically read by FileSDbAcqReads. | FLOAT |
FileTJtAcqReadKB | count | KB physically read by FileTJtAcqReads. | FLOAT |