oracle 12c 关闭统计信息收集和启用统计信息收集

oracle 12c 关闭统计信息收集和启用统计信息收集

--关闭统计信息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>