自动数据库维护任务管理

EXEC DBMS_AUTO_TASK_ADMIN.disable;


EXEC DBMS_AUTO_TASK_ADMIN.enable;


BEGIN
DBMS_AUTO_TASK_ADMIN.disable(
client_name => ‘auto space advisor’,
operation => NULL,
window_name => NULL);
END;
/


BEGIN
DBMS_AUTO_TASK_ADMIN.enable(
client_name => ‘auto space advisor’,
operation => NULL,
window_name => NULL);
END;
/


BEGIN
DBMS_AUTO_TASK_ADMIN.disable(
client_name => ‘auto optimizer stats collection’,
operation => NULL,
window_name => ‘MONDAY_WINDOW’);

DBMS_AUTO_TASK_ADMIN.disable(
client_name => ‘auto space advisor’,
operation => NULL,
window_name => ‘MONDAY_WINDOW’);

DBMS_AUTO_TASK_ADMIN.disable(
client_name => ‘sql tuning advisor’,
operation => NULL,
window_name => ‘MONDAY_WINDOW’);
END;
/



EXEC DBMS_STATS.alter_stats_history_retention（90）;
EXEC DBMS_STATS.set_global_prefs（‘estimate_percent’，‘5’）;



BEGIN
DBMS_SQLTUNE.set_tuning_task_parameter(‘SYS_AUTO_SQL_TUNING_TASK’, ‘LOCAL_TIME_LIMIT’, 1000);
DBMS_SQLTUNE.set_tuning_task_parameter(‘SYS_AUTO_SQL_TUNING_TASK’, ‘ACCEPT_SQL_PROFILES’, ‘FALSE’);
DBMS_SQLTUNE.set_tuning_task_parameter(‘SYS_AUTO_SQL_TUNING_TASK’, ‘MAX_SQL_PROFILES_PER_EXEC’, 30);
DBMS_SQLTUNE.set_tuning_task_parameter(‘SYS_AUTO_SQL_TUNING_TASK’, ‘MAX_AUTO_SQL_PROFILES’, 10100);
END;
/


维护窗口配置


BEGIN
DBMS_SCHEDULER.disable(
name => ‘SYS.MAINTENANCE_WINDOW_GROUP’,
force => TRUE);
END;
/


BEGIN
DBMS_SCHEDULER.enable(
name => ‘SYS.MAINTENANCE_WINDOW_GROUP’);
END;
/





BEGIN
DBMS_SCHEDULER.disable(name => ‘SYS.MONDAY_WINDOW’, force => TRUE);

DBMS_SCHEDULER.set_attribute(
name => ‘SYS.MONDAY_WINDOW’,
attribute => ‘DURATION’,
value => numtodsinterval(180, ‘minute’));

DBMS_SCHEDULER.enable(name=>‘SYS.MONDAY_WINDOW’);
END;
/


资源计划配置


编辑此计划或创建一个新计划