DBA Data[Home] [Help]

VIEW: SYS.GV_$MTTR_TARGET_ADVICE

Source

View Text - Preformatted

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
View Text - HTML Formatted

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