GV$MEMORY_TARGET_ADVICE definition in Oracle Database 11.2
GV$MEMORY_TARGET_ADVICE
select
A.inst_id, -- INST_ID NUMBER
A.memsz, -- MEMORY_SIZE NUMBER
round((A.memsz / A.base_memsz), 4), -- MEMORY_SIZE_FACTOR NUMBER
decode( -- ESTD_DB_TIME NUMBER
A.base_estd_dbtime,0,to_number(null), round(A.base_dbtime * round((A.dbtime / A.base_estd_dbtime), 4), 0)),
decode( -- ESTD_DB_TIME_FACTOR NUMBER
A.base_estd_dbtime,0,to_number(null), round((A.dbtime / A.base_estd_dbtime), 4)),
A.version -- VERSION NUMBER
from
x$kmgsbsmemadv A
order by
A.inst_id,
A.memsz