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')