11g scheduler disable

GATHER_STATS_JOB

11g 설치후 기본 Scheduler 기능 비활성화 작업

기본적으로 3가지의 job이 등록되어 있음

- 11g -

execute DBMS_AUTO_TASK_ADMIN.DISABLE;

- 10g -

excute DBMS_STATS.DISABLE;

select client_name, status, consumer_group from dba_autotask_client;

CLIENT_NAME                                                      STATUS   CONSUMER_GROUP

---------------------------------------------------------------- -------- ------------------------------

auto optimizer stats collection                                  ENABLED ORA$AUTOTASK_STATS_GROUP

auto space advisor                                               ENABLED  ORA$AUTOTASK_SPACE_GROUP

sql tuning advisor                                               ENABLED  ORA$AUTOTASK_SQL_GROUP

- 해제 -

BEGIN

  dbms_auto_task_admin.disable(

  client_name => 'auto optimizer stats collection',

  operation => NULL,

  window_name => NULL);

END;  

/

BEGIN

  dbms_auto_task_admin.disable(

  client_name => 'auto space advisorr',

  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.enable(

  client_name => 'auto optimizer stats collection',

  operation => NULL,

  window_name => NULL);

END;  

/

BEGIN

  dbms_auto_task_admin.enable(

  client_name => 'auto space advisorr',

  operation => NULL,

  window_name => NULL);

END;  

/

BEGIN

  dbms_auto_task_admin.enable(

  client_name => 'sql tuning advisor',

  operation => NULL,

  window_name => NULL);

END;  

/