52.Oracle杂记——Oracle常用动态视图v$filestat

52.Oracle杂记——Oracle常用动态视图v$filestat

视图v$filestat显示文件级别的物理读写，单独块的总数。

           视图描述如下：

idle> desc v$filestat;

 Name                                                                  Null?    Type

 ------------------------------------------------------------- ------------------------------------

 FILE#                                                                                 NUMBER

 PHYRDS                                                                           NUMBER

 PHYWRTS                                                                        NUMBER

 PHYBLKRD                                                                        NUMBER

 OPTIMIZED_PHYBLKRD                                                        NUMBER

 PHYBLKWRT                                                                    NUMBER

 SINGLEBLKRDS                                                                         NUMBER

 READTIM                                                                         NUMBER

 WRITETIM                                                                      NUMBER

 SINGLEBLKRDTIM                                                       NUMBER

 AVGIOTIM                                                                      NUMBER

 LSTIOTIM                                                                        NUMBER

 MINIOTIM                                                                      NUMBER

 MAXIORTM                                                                    NUMBER

 MAXIOWTM                                                                  NUMBER

 CON_ID                                                                           NUMBER

各个列的含义如下：

FILE#：文件号

 PHYRDS ：物理读次数

 PHYWRTS：物理写次数

 PHYBLKRD：物理块读数量

 OPTIMIZED_PHYBLKRD   ：从Smart Flash Cache blocks中的物理读次数

 PHYBLKWRT：写到磁盘的块数量，如果所有写都是单块，那么和PHYWRTS一样

 SINGLEBLKRDS：单块读的数量

 READTIM：花在读上的时间

 WRITETIM：花在写上的时间

 SINGLEBLKRDTIM：单块读的次数

 AVGIOTIM：花在IO上的平均时间

 LSTIOTIM：上一个IO的时间

 MINIOTIM：单个IO的最小时间

 MAXIORTM：单个读IO的最大时间

 MAXIOWTM：单个写IO的最大时间

 CON_ID：容器ID