|
一、开启与封锁自动网络统计信息
1、查察是否开启
select client_name,status from dba_autotask_client;
?
2、开启
exec DBMS_AUTO_TASK_ADMIN.ENABLE(client_name => ‘auto optimizer stats collection‘,operation => NULL,window_name => NULL);
?
3、封锁
exec DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => ‘auto optimizer stats collection‘,window_name => NULL);
二、调解数据库自动信息收罗
1、查察天天自动信息收罗时刻
SELECT w.window_name,
?????????????? w.repeat_interval,
?????????????? w.duration,
?????????????? w.enabled
????????? FROM dba_autotask_window_clients c,dba_scheduler_windows w
???????? WHERE c.window_name = w.window_name AND c.optimizer_stats = ‘ENABLED‘;
2、封锁单个调治时刻窗口
??????? BEGIN
?????????? DBMS_AUTO_TASK_ADMIN.disable (
????????????? client_name?? => ‘auto optimizer stats collection‘,
????????????? operation???? => NULL,
????????????? window_name?? => ‘MONDAY_WINDOW‘);
??????? END;
/
周一已经封锁
3、开启单个调治时刻窗口及全部时刻调治窗口，只必要行使enable进程
??????? -- 注：单个应指定窗口名字，如window_name?? => ‘MONDAY_WINDOW‘
??????? BEGIN
?????????? DBMS_AUTO_TASK_ADMIN.enable (
????????????? client_name?? => ‘auto optimizer stats collection‘,
????????????? window_name?? => NULL);
??????? END;
/
4、
（编辑：湖南网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
