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 |