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

home |  up