GV$MTTR_TARGET_ADVICE

select
distinct inst_id,        -- INST_ID NUMBER
mttr_v,                  -- MTTR_TARGET_FOR_ESTIMATE NUMBER
decode                   -- ADVICE_STATUS VARCHAR2(5)
  (status, 0, 'OFF', 4, 'ON', 'READY'),
decode                   -- DIRTY_LIMIT NUMBER
  (dirty_limit, 0, to_number (NULL), dirty_limit),
decode                   -- ESTD_CACHE_WRITES NUMBER
  (factored_sim_writes, -1, to_number (NULL), factored_sim_writes),
decode                   -- ESTD_CACHE_WRITE_FACTOR NUMBER
  (base_real_nondirect_writes, 0, to_number (NULL), decode (factored_sim_writes, -1, to_number (NULL), round ((factored_sim_writes / base_real_nondirect_writes), 4))),
decode                   -- ESTD_TOTAL_WRITES NUMBER
  (total_writes, -1, to_number (NULL), total_writes),
decode                   -- ESTD_TOTAL_WRITE_FACTOR NUMBER
  (base_total_writes, 0, to_number (NULL), decode (total_writes, -1, to_number (NULL), round ((total_writes / base_total_writes), 4))),
decode                   -- ESTD_TOTAL_IOS NUMBER
  (total_ios, -1, to_number (NULL), total_ios),
decode                   -- ESTD_TOTAL_IO_FACTOR NUMBER
  (base_total_ios, 0, to_number (NULL), decode (total_ios, -1, to_number (NULL), round ((total_ios / base_total_ios), 4))) 
from
x$kcbmmav
home |  up  |  mailbox