Change Auto tune status manually on 11g

berikut adalah cara untuk menonaktifkan dan mengaktifkan auto tune management di

11g secara manual

execute script berikut untuk mendapatkan list auto task window :

/* Formatted on 2009/07/28 15:47 (Formatter Plus v4.8.8) */

SELECT a.window_name, a.window_active, a.autotask_status, a.optimizer_stats,

a.segment_advisor, a.sql_tune_advisor, a.health_monitor

FROM dba_autotask_window_clients a;

MONDAY_WINDOW

TUESDAY_WINDOW

WEDNESDAY_WINDOW

THURSDAY_WINDOW

FRIDAY_WINDOW

SATURDAY_WINDOW

SUNDAY_WINDOW

BEGIN

dbms_auto_task_admin.enable(client_name => 'auto space advisor', operation => NULL, window_name => 'SATURDAY_WINDOW');

END;

BEGIN

dbms_auto_task_admin.disable(client_name => 'auto optimizer stats collection', operation => NULL, window_name => 'THURSDAY_WINDOW');

END;