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