V$MTTR_TARGET_ADVICE definition in Oracle Database 11.2
V$MTTR_TARGET_ADVICE

select
  mttr_target_for_estimate,                -- MTTR_TARGET_FOR_ESTIMATE NUMBER
  advice_status,                           -- ADVICE_STATUS VARCHAR2(5)
  dirty_limit,                             -- DIRTY_LIMIT NUMBER
  estd_cache_writes,                       -- ESTD_CACHE_WRITES NUMBER
  estd_cache_write_factor,                 -- ESTD_CACHE_WRITE_FACTOR NUMBER
  estd_total_writes,                       -- ESTD_TOTAL_WRITES NUMBER
  estd_total_write_factor,                 -- ESTD_TOTAL_WRITE_FACTOR NUMBER
  estd_total_ios,                          -- ESTD_TOTAL_IOS NUMBER
  estd_total_io_factor                     -- ESTD_TOTAL_IO_FACTOR NUMBER
from
  gv$mttr_target_advice
where
  inst_id = userenv('instance')

home |  up