ITPub博客

首页 > Linux操作系统 > Linux操作系统 > V$LIBRARYCACHE

V$LIBRARYCACHE

原创 Linux操作系统 作者:bbs159 时间:2011-05-23 10:13:05 0 删除 编辑

V$LIBRARYCACHE

This view contains statistics about library cache performance and activity.

Column Datatype Description
NAMESPACE VARCHAR2(15) Library cache namespace
GETS NUMBER Number of times a lock was requested for objects of this namespace
GETHITS NUMBER Number of times an object's handle was found in memory
GETHITRATIO NUMBER Ratio of GETHITS to GETS
PINS NUMBER Number of times a PIN was requested for objects of this namespace
PINHITS NUMBER Number of times all of the metadata pieces of the library object were found in memory
PINHITRATIO NUMBER Ratio of PINHITS to PINS
RELOADS NUMBER Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk
INVALIDATIONS NUMBER The total number of times objects in this namespace were marked invalid because a dependent object was modified
DLM_LOCK_REQUESTS NUMBER Number of GET requests lock instance locks
DLM_PIN_REQUESTS NUMBER Number of PIN requests lock instance locks
DLM_PIN_RELEASES NUMBER Number of release requests PIN instance locks
DLM_INVALIDATION_REQUESTS NUMBER Number of GET requests for invalidation instance locks
DLM_INVALIDATIONS NUMBER Number of invalidation pings received from other instances
 
视图列表:描述了LIBRARY CACHE性能和主要指标
 NAMESPACE  空间名称
 GETS    获得对象(SQL语句)
 GETHITS  找到了获得对象
 GETHITRATIO
 PINS     执行请求次数
 PINHITS 执行请求合中率
 PINHITRATIO
 RELOADS 重新对象加载次数
 INVALIDATIONS  失效加载次数
 DLM_LOCK_REQUESTS
 DLM_PIN_REQUESTS
 DLM_PIN_RELEASES
 DLM_INVALIDATION_REQUESTS
 DLM_INVALIDATIONS

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13824386/viewspace-696020/,如需转载,请注明出处,否则将追究法律责任。

上一篇: V$SHARED_POOL_ADVICE
请登录后发表评论 登录
全部评论

注册时间:2011-05-11

  • 博文量
    26
  • 访问量
    41951