oracle 12c 关闭统计信息收集和启用统计信息收集
发布时间:2020-12-12 14:07:18 所属栏目:百科 来源:网络整理
导读:oracle 12c 关闭统计信息收集和启用统计信息收集 --关闭统计信息col client_name for a60select client_name,status from DBA_AUTOTASK_CLIENT;CLIENT_NAME STATUS------------------------------------------------------------ ----------------auto optim
oracle 12c 关闭统计信息收集和启用统计信息收集--关闭统计信息 col client_name for a60 select client_name,status from DBA_AUTOTASK_CLIENT; CLIENT_NAME STATUS ------------------------------------------------------------ ---------------- auto optimizer stats collection ENABLED auto space advisor ENABLED sql tuning advisor ENABLED begin DBMS_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 DISABLED auto space advisor ENABLED sql tuning advisor ENABLED SQL> begin DBMS_AUTO_TASK_ADMIN.ENABLE(client_name => 'auto optimizer stats collection',window_name => NULL); end; / PL/SQL procedure successfully completed. select client_name,status from DBA_AUTOTASK_CLIENT; CLIENT_NAME STATUS ------------------------------------------------------------ ---------------- auto optimizer stats collection ENABLED auto space advisor ENABLED sql tuning advisor ENABLED SQL> (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |