Question

请教v$filestat 中字段的含义

Answer 1

Column
Datatype
Description

FILE#
NUMBER
Number of the file 文件号

PHYRDS
NUMBER
Number of physical reads done 物理读次数

PHYWRTS
NUMBER
Number of times DBWR is required to write DBWR写次数

PHYBLKRD
NUMBER
Number of physical blocks read 物理读块数

PHYBLKWRT
NUMBER
Number
of blocks written to disk, which may be the same as PHYWRTS if all
writes are single blocks 写到磁盘的块数，如果所有的写均是单块写，则与PHYWRTS的值相同。

SINGLEBLKRDS
NUMBER
Number of single block reads 单块读次数

READTIM
NUMBER
Time
(in hundredths of a second) spent doing reads if the TIMED_STATISTICS
parameter istrue; 0 if false 读花费的时间（单位为百分之一秒，即1表示10ms)。如果
TIMED_STATISTICS参数设置为FALSE，则此处值为0.

WRITETIM
NUMBER
Time (in hundredths of a second) spent doing writes if the TIMED_STATISTICS parameter istrue; 0 if false 写花费的时间（后同READTIM的说明）

SINGLEBLKRDTIM
NUMBER
Cumulative single block read time (in hundredths of a second) 累计的单块读时间（单位为百分之一秒）

AVGIOTIM
NUMBER
Average time (in hundredths of a second) spent on I/O, if the TIMED_STATISTICS parameter is true; 0 if false I/O花费的平均时间（后同READTIM的说明）

LSTIOTIM
NUMBER
Time (in hundredths of a second) spent doing the last I/O, if the TIMED_STATISTICSparameter is true; 0 if false 最近一次I/O花费的时间（后同READTIM的说明）

MINIOTIM
NUMBER
Minimum
time (in hundredths of a second) spent on a single I/O, if the
TIMED_STATISTICSparameter is true; 0 if false 单次I/O花费的最小时间（后同READTIM的说明）

MAXIORTM
NUMBER
Maximum
time (in hundredths of a second) spent doing a single read, if
theTIMED_STATISTICS parameter is true; 0 if false 单次读花费的最大时间（后同READTIM的说明）

MAXIOWTM
NUMBER
Maximum
time (in hundredths of a second) spent doing a single write, if
theTIMED_STATISTICS parameter is true; 0 if false 单次写花费的最大时间（后同READTIM的说明）