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 |