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	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.