Désactiver les AUTO_TASK

SET LINESIZE 2000
COL CLIENT_NAME FOR A50
COL ATTRIBUTES FOR A70
SELECT CLIENT_NAME, STATUS, ATTRIBUTES
  FROM DBA_AUTOTASK_CLIENT ;


CLIENT_NAME                          STATUS    ATTRIBUTES
------------------------------------ --------- ----------------------------------------------------------------
auto optimizer stats collection      ENABLED   ON BY DEFAULT, VOLATILE, SAFE TO KILL
auto space advisor                   ENABLED   ON BY DEFAULT, VOLATILE, SAFE TO KILL
sql tuning advisor                   ENABLED   ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL

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

BEGIN
  DBMS_AUTO_TASK_ADMIN.disable(
    client_name => 'sql tuning advisor', 
    operation   => NULL, 
    window_name => NULL);
END;
/

BEGIN
  DBMS_AUTO_TASK_ADMIN.disable(
    client_name => 'auto optimizer stats collection', 
    operation   => NULL,
    window_name => NULL);
END;
/


SET LINESIZE 2000
COL CLIENT_NAME FOR A50
COL ATTRIBUTES FOR A70
SELECT CLIENT_NAME, STATUS, ATTRIBUTES
  FROM DBA_AUTOTASK_CLIENT ;

CLIENT_NAME                          STATUS    ATTRIBUTES
------------------------------------ --------- ----------------------------------------------------------------
auto optimizer stats collection      DISABLED  ON BY DEFAULT, VOLATILE, SAFE TO KILL
auto space advisor                   DISABLED  ON BY DEFAULT, VOLATILE, SAFE TO KILL
sql tuning advisor                   DISABLED  ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL



Pour les réactiver : 

BEGIN
  DBMS_AUTO_TASK_ADMIN.enable(
     client_name => 'NomduAdvisor', 
     operation   => NULL, 
     window_name => NULL);
END;

/