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')