oracle 12c 關閉統計資訊收集和啟用統計資訊收集

標籤：select   acl   ora   complete   啟用   rom   disabled   space   pre   

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> 

oracle 12c 關閉統計資訊收集和啟用統計資訊收集