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