oracle自動維護

字號:


    檢查ORACLE自動維護任務是否關閉
    SQL> select t.client_name, t.status from dba_autotask_client t;
    CLIENT_NAME STATUS
    ---------------------------------------------------------------- --------
    auto optimizer stats collection DISABLED
    auto space advisor DISABLED
    sql tuning advisor DISABLED
    SQL>