蛤蟆 Oracle,52.蛤蟆的Oracle杂记——Oracle常用动态视图v$filestat

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

欢迎转载，转载请标明出处：http://blog.csdn.net/notbaron/article/details/50539522

视图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