p27.sql

来自「oracal的入门知识」· SQL 代码 · 共 8 行

select MTTR_TARGET_FOR_ESTIMATE MttrEst,
        ADVICE_STATUS AD,
        DIRTY_LIMIT DL,
        ESTD_CACHE_WRITES ESTCW,
        ESTD_CACHE_WRITE_FACTOR EstCWF,ESTD_TOTAL_WRITES ESTW,
        ESTD_TOTAL_WRITE_FACTOR ETWF,ESTD_TOTAL_IOS ETIO
 from v$mttr_target_advice;