V$LIBRARYCACHE

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13824386/viewspace-696020/