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.

**Table 1** PV_FILE_STAT columns
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