V$SGA_TARGET_ADVICE definition in Oracle Database 11.2
V$SGA_TARGET_ADVICE

select
  sga_size,                                -- SGA_SIZE NUMBER
  sga_size_factor,                         -- SGA_SIZE_FACTOR NUMBER
  estd_db_time,                            -- ESTD_DB_TIME NUMBER
  estd_db_time_factor,                     -- ESTD_DB_TIME_FACTOR NUMBER
  estd_physical_reads                      -- ESTD_PHYSICAL_READS NUMBER
from
  gv$sga_target_advice
where
  inst_id = userenv('instance')

home |  up