Oracle 视图 V$LIBRARYCACHE 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 V$LIBRARYCACHE 官方解释，作用，如何使用详细说明 10-15

本站中文解释

Oracle视图V$LIBRARYCACHE用于查询被缓存在shard pool (SP) 中的shared SQL cursors，以及在各个会话会话中使用次数。

使用方法：
1、查询缓存在SP中的SQL语句：
SELECT SQL_TEXT
FROM V$LIBRARYCACHE
WHERE namespace = ‘SQL AREA’;

2、查询会话中使用SQL次数：
SELECT *
FROM V$LIBRARYCACHE
WHERE SESSION_ADDR = ‘SESSION ADDRESS’;

官方英文解释

V$LIBRARYCACHE contains statistics about library cache performance and activity.

Column	Datatype	Description
`NAMESPACE`	`VARCHAR2(64)`	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`	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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

编辑：568数据

标签：缓存,次数,英文,视图,中文