21.Oracle杂记——Oracle常用动态视图v$librarycache

21.Oracle杂记——Oracle常用动态视图v$librarycache

视图v$librarycache：共享池中SQL语句的管理信息，包含库缓存中的性能和活动。

描述如下：

sys@PDB1> desc v$librarycache;

 Name                                                                                                     Null?         Type

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

 NAMESPACE                                                                                                                    VARCHAR2(64)

 GETS                                                                                                                                   NUMBER

 GETHITS                                                                                                                            NUMBER

 GETHITRATIO                                                                                                                  NUMBER

 PINS                                                                                                                                    NUMBER

 PINHITS                                                                                                                             NUMBER

 PINHITRATIO                                                                                                                   NUMBER

 RELOADS                                                                                                                           NUMBER

 INVALIDATIONS                                                                                                                               NUMBER

 DLM_LOCK_REQUESTS                                                                                               NUMBER

 DLM_PIN_REQUESTS                                                                                                   NUMBER

 DLM_PIN_RELEASES                                                                                                    NUMBER

 DLM_INVALIDATION_REQUESTS                                                                           NUMBER

 DLM_INVALIDATIONS                                                                                                 NUMBER

 CON_ID                                                                                                                            NUMBER

每列描述如下：

NAMESPACE：库缓存的命名空间，例如SQL AREA

 GETS：这个命名空间内，对象请求锁的次数

 GETHITS                ：在内存中命中的次数

 GETHITRATIO      ：命中比例

 PINS：这个命名空间内 对象请求PIN的次数

 PINHITS                 ： 库对象在内存中找到的次数

 PINHITRATIO       ：PIN命中的比例

 RELOADS：对象句柄被创建后，重新从磁盘PIN 到内存的次数

 INVALIDATIONS：对象被标记为无效的次数

 DLM_LOCK_REQUESTS     ：请求GET lock的次数

 DLM_PIN_REQUESTS：请求PIN lock的次数

 DLM_PIN_RELEASES： 请求释放PIN的次数

 DLM_INVALIDATION_REQUESTS   ：请求GET无效的次数

 DLM_INVALIDATIONS：来自其他实例的无效ping

 CON_ID：保持数据的容器ID。