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.
Name | Type | Description |
|---|---|---|
filenum | oid | File ID |
dbid | oid | Database ID |
spcid | oid | ID of a tablespace |
phyrds | bigint | Number of times of reading physical files |
phywrts | bigint | Number of times of writing into physical files |
phyblkrd | bigint | Number of times of reading physical file blocks |
phyblkwrt | bigint | Number of times of writing into physical file blocks |
readtim | bigint | Total duration of reading files, in microseconds |
writetim | bigint | Total duration of writing files, in microseconds |
avgiotim | bigint | Average duration of reading and writing files, in microseconds |
lstiotim | bigint | Duration of the last file reading, in microseconds |
miniotim | bigint | Minimum duration of reading and writing files, in microseconds |
maxiowtm | bigint | Maximum duration of reading and writing files, in microseconds |