29.Oracle杂记——Oracle常用动态视图v$rowcache

29.Oracle杂记——Oracle常用动态视图v$rowcache

视图v$rowcache：内存中数据字典活动/性能信息

视图描述如下：

sys@PDB1> desc v$rowcache;

 Name                                                                                                     Null?         Type

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

 CACHE#                                                                                                                            NUMBER

 TYPE                                                                                                                                    VARCHAR2(11)

 SUBORDINATE#                                                                                                              NUMBER

 PARAMETER                                                                                                                    VARCHAR2(32)

 COUNT                                                                                                                               NUMBER

 USAGE                                                                                                                                NUMBER

 FIXED                                                                                                                                  NUMBER

 GETS                                                                                                                                   NUMBER

 FASTGETS                                                                                                                         NUMBER

 GETMISSES                                                                                                                      NUMBER

 SCANS                                                                                                                                NUMBER

 SCANMISSES                                                                                                                   NUMBER

 SCANCOMPLETES                                                                                                                            NUMBER

 MODIFICATIONS                                                                                                                             NUMBER

 FLUSHES                                                                                                                            NUMBER

 DLM_REQUESTS                                                                                                                              NUMBER

 DLM_CONFLICTS                                                                                                                             NUMBER

 DLM_RELEASES                                                                                                              NUMBER

 CON_ID                                                                                                                            NUMBER

各个列的含义：

CACHE#                   ： 行CACHE 的ID号

 TYPE：  上级或下级 行CACHE类型

 SUBORDINATE#：下级 设置号

 PARAMETER：初始化参数名字，该参数决定了数据字典CACHE中条目的数量。

 COUNT：CACHE中总条目数

 USAGE  ：包含合法数据的CACHE条目

 FIXED：在CACHE中固定的条目

 GETS：数据对象信息请求的总次数

 FASTGETS：内部使用保留

 GETMISSES：在CACHE中请求数据失败次数

 SCANS：扫描请求的次数

 SCANMISSES       ：在CACHE中扫描未命中次数

 SCANCOMPLETES：对于下级条目列表，列表完全扫描的次数

 MODIFICATIONS：插入，更新和删除的次数

 FLUSHES：刷到磁盘的次数

 DLM_REQUESTS                  ：DLM请求次数

 DLM_CONFLICTS                 ：DLM冲突次数

 DLM_RELEASES：DLM释放次数

 CON_ID ：容器ID