本文共 1656 字，大约阅读时间需要 5 分钟。
--关闭统计信息col client_name for a60select client_name,status from DBA_AUTOTASK_CLIENT;CLIENT_NAME STATUS------------------------------------------------------------ ----------------auto optimizer stats collection ENABLEDauto space advisor ENABLEDsql tuning advisor ENABLEDbeginDBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto optimizer stats collection',operation => NULL,window_name => NULL);end;/PL/SQL procedure successfully completed.--启用统计信息收集select client_name,status from DBA_AUTOTASK_CLIENT;CLIENT_NAME STATUS------------------------------------------------------------ ----------------auto optimizer stats collection DISABLEDauto space advisor ENABLEDsql tuning advisor ENABLEDSQL> beginDBMS_AUTO_TASK_ADMIN.ENABLE(client_name => 'auto optimizer stats collection',operation => NULL,window_name => NULL);end;/PL/SQL procedure successfully completed.select client_name,status from DBA_AUTOTASK_CLIENT;CLIENT_NAME STATUS------------------------------------------------------------ ----------------auto optimizer stats collection ENABLEDauto space advisor ENABLEDsql tuning advisor ENABLEDSQL>