GV$SHARED_POOL_ADVICE definition in Oracle 10g / www.oracledba.ru
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