PV_FILE_STAT
By collecting statistics about the data file I/Os, PV_FILE_STAT displays the I/O performance of the data to detect the performance problems, such as abnormal I/O operations.
| Column | Type | Description |
|---|---|---|
| filenum | OID | File ID. |
| dbid | OID | Database ID. |
| spcid | OID | Tablespace ID. |
| phyrds | Bigint | Number of physical files read. |
| phywrts | Bigint | Number of physical files written. |
| phyblkrd | Bigint | Number of physical file blocks read. |
| phyblkwrt | Bigint | Number of physical file blocks written. |
| readtim | Bigint | Total duration of file reads, in microseconds. |
| writetim | Bigint | Total duration of file writes, in microseconds. |
| avgiotim | Bigint | Average duration of file reads and writes, in microseconds. |
| lstiotim | Bigint | Duration of the last file read, in microseconds. |
| miniotim | Bigint | Minimum duration of file reads and writes, in microseconds. |
| maxiowtm | Bigint | Maximum duration of file reads and writes, in microseconds. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
