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 |