select
  memory_size,                             -- MEMORY_SIZE NUMBER
  memory_size_factor,                      -- MEMORY_SIZE_FACTOR NUMBER
  estd_db_time,                            -- ESTD_DB_TIME NUMBER
  estd_db_time_factor,                     -- ESTD_DB_TIME_FACTOR NUMBER
  version                                  -- VERSION NUMBER
from
  gv$memory_target_advice
where
  inst_id = userenv('instance')