GV$SHARED_POOL_ADVICE definition in Oracle 9i / 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_hits -- ESTD_LC_MEMORY_OBJECT_HITS NUMBER
from
x$kglsim