Oracle 12c Turn off statistics collection and enable statistics collection
--Turn off statistics 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_tas K_admin. DISABLE (client_name = ' Auto Optimizer stats collection ', operation = Null,window_name = NULL); end;/pl/sql Procedure successfully completed.--enable statistics collection 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 Turn off statistics collection and enable statistics collection