GV$JAVA_POOL_ADVICE definition in Oracle Database 11.2
GV$JAVA_POOL_ADVICE

select
  inst_id,                                 -- INST_ID NUMBER
  java_size,                               -- JAVA_POOL_SIZE_FOR_ESTIMATE NUMBER
  round(java_size / basejava_size, 4),     -- JAVA_POOL_SIZE_FACTOR NUMBER
  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