关闭空间顾问和sql优化顾问

oacle 11g以上

BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'auto space advisor',
operation => NULL,
window_name => NULL);
END;
/
关闭数据库的空间Advisor，避免消耗过多的IO，还有避免出现这个任务引起的library cache lock。
BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/

oracle 10g

execute dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB');