GV$SHARED_POOL_ADVICE

select
inst_id,                 -- INST_ID NUMBER
sp_size,                 -- SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
round                    -- SHARED_POOL_SIZE_FACTOR NUMBER
  (sp_size / basesp_size, 4),
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
home |  up  |  mailbox