Shulou(Shulou.com)06/01 Report--

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_TASK_ADMIN.DISABLE (client_name = > 'auto optimizer stats collection' Operation = > NULL,window_name = > NULL) End;/PL/SQL procedure successfully completed.-- enables 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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.