Oracle教程

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

本站中文解释

Oracle视图V$LIBRARY_CACHE_MEMORY显示用于存储库缓存的内存信息。包括当前已分配的内存大小，总共的分配的内存大小，峰值分配量，将库缓存对象加载到内存的次数，以及其他有关库缓存的内存信息。

使用视图V$LIBRARY_CACHE_MEMORY来识别库缓存使用的内存量，检查库缓存是否有正确分配了足够的内存，并确定库缓存状态是否受到内存约束。库缓存内存使用情况可以通过对比“CURRENT_SIZE”和“ALLOCATED_SIZE”来查看。如果CURRENT_SIZE小于ALLOCATED_SIZE，则表明内存是受限制的；如果CURRENT_SIZE等于ALLOCATED_SIZE，则表明库缓存没有受到内存限制。

官方英文解释

V$LIBRARY_CACHE_MEMORY displays information about memory allocated to library cache memory objects in different namespaces.

A memory object is an internal grouping of memory for efficient management. A library cache object may consist of one or more memory objects.

Column Datatype Description

LC_NAMESPACE

VARCHAR2(15)

Library cache namespace

LC_INUSE_MEMORY_OBJECTS

NUMBER

Number of library cache memory objects currently in use in the shared pool

LC_INUSE_MEMORY_SIZE

NUMBER

Total size of library cache in-use memory objects (in megabytes)

LC_FREEABLE_MEMORY_OBJECTS

NUMBER

Number of freeable library cache memory objects in the shared pool

LC_FREEABLE_MEMORY_SIZE

NUMBER

Size of library cache freeable memory objects (in megabytes)

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


数据运维技术 » Oracle 视图 V$LIBRARY_CACHE_MEMORY 官方解释，作用，如何使用详细说明
分享到：

相关推荐