select "INST_ID","MTTR_TARGET_FOR_ESTIMATE","ADVICE_STATUS","DIRTY_LIMIT","ESTD_CACHE_WRITES","ESTD_CACHE_WRITE_FACTOR","ESTD_TOTAL_WRITES","ESTD_TOTAL_WRITE_FACTOR","ESTD_TOTAL_IOS","ESTD_TOTAL_IO_FACTOR","CON_ID" from
gv$mttr_target_advice
SELECT "INST_ID"
, "MTTR_TARGET_FOR_ESTIMATE"
, "ADVICE_STATUS"
, "DIRTY_LIMIT"
, "ESTD_CACHE_WRITES"
, "ESTD_CACHE_WRITE_FACTOR"
, "ESTD_TOTAL_WRITES"
, "ESTD_TOTAL_WRITE_FACTOR"
, "ESTD_TOTAL_IOS"
, "ESTD_TOTAL_IO_FACTOR"
, "CON_ID" FROM
GV$MTTR_TARGET_ADVICE
|
|
|