GV$JAVA_POOL_ADVICE

select
inst_id,                 -- INST_ID NUMBER
java_size,               -- JAVA_POOL_SIZE_FOR_ESTIMATE NUMBER
round                    -- JAVA_POOL_SIZE_FACTOR NUMBER
  (java_size / basejava_size, 4),
kgljsim_size,            -- ESTD_LC_SIZE NUMBER
kgljsim_objs,            -- ESTD_LC_MEMORY_OBJECTS NUMBER
kgljsim_timesave,        -- ESTD_LC_TIME_SAVED NUMBER
decode                   -- ESTD_LC_TIME_SAVED_FACTOR NUMBER
  (kgljsim_basetimesave, 0, to_number (null), round (kgljsim_timesave / kgljsim_basetimesave, 4)),
kgljsim_parsetime,       -- ESTD_LC_LOAD_TIME NUMBER
decode                   -- ESTD_LC_LOAD_TIME_FACTOR NUMBER
  (kgljsim_baseparsetime, 0, to_number (null), round (kgljsim_parsetime / kgljsim_baseparsetime, 4)),
kgljsim_hits             -- ESTD_LC_MEMORY_OBJECT_HITS NUMBER
from
x$kgljsim
home |  up  |  mailbox