Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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)