本站中文解释
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 |
|---|---|---|
|
|
|
Library cache namespace |
|
|
|
Number of library cache memory objects currently in use in the shared pool |
|
|
|
Total size of library cache in-use memory objects (in megabytes) |
|
|
|
Number of freeable library cache memory objects in the shared pool |
|
|
|
Size of library cache freeable memory objects (in megabytes) |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
