select lc_namespace, -- LC_NAMESPACE VARCHAR2(15) lc_inuse_memory_objects, -- LC_INUSE_MEMORY_OBJECTS NUMBER lc_inuse_memory_size, -- LC_INUSE_MEMORY_SIZE NUMBER lc_freeable_memory_objects, -- LC_FREEABLE_MEMORY_OBJECTS NUMBER lc_freeable_memory_size -- LC_FREEABLE_MEMORY_SIZE NUMBER from gv$java_library_cache_memory where inst_id = USERENV('Instance')