select
  inst_id,                                 -- INST_ID NUMBER
  sp_size,                                 -- SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
  round(sp_size / basesp_size, 4),         -- SHARED_POOL_SIZE_FACTOR NUMBER
  kglsim_size,                             -- ESTD_LC_SIZE NUMBER
  kglsim_objs,                             -- ESTD_LC_MEMORY_OBJECTS NUMBER
  kglsim_timesave,                         -- ESTD_LC_TIME_SAVED NUMBER
  decode(                                  -- ESTD_LC_TIME_SAVED_FACTOR NUMBER
    kglsim_basetimesave, 0, to_number(null), round(kglsim_timesave / kglsim_basetimesave, 4)),
  kglsim_parsetime,                        -- ESTD_LC_LOAD_TIME NUMBER
  decode(                                  -- ESTD_LC_LOAD_TIME_FACTOR NUMBER
    kglsim_baseparsetime, 0, to_number(null), round(kglsim_parsetime / kglsim_baseparsetime, 4)),
  kglsim_hits                              -- ESTD_LC_MEMORY_OBJECT_HITS NUMBER
from
  x$kglsim