자동 ANALYZE 스케쥴러 작업 해지

 오라클 10g에서 디폴트로 걸려있는 SCHEDULER를 확인.

 

SQL> connect /as sysdba

SQL> SELECT OWNER, JOB_NAME, JOB_CREATOR, STATE FROM DBA_SCHEDULER_JOBS ;

 

OWNER                          JOB_NAME                       JOB_CREATOR                    STATE

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

SYS                            PURGE_LOG                      SYS                            SCHEDULED

SYS                            FGR$AUTOPURGE_JOB              SYS                            DISABLED

SYS                            GATHER_STATS_JOB               SYS                            SCHEDULED

SYS                            AUTO_SPACE_ADVISOR_JOB         SYS                            SCHEDULED

 

 'STATE' 항목에 'SCHEDULED'로 표시된 항목이 현재 SCHEDULER가 걸려있는 것이다. 이를 DISABLED 시키면 자동스케줄러 작업이 해지된다.

 

자동 Analyze 스케줄러 작업을 해지 시키기

 

SQL> EXEC DBMS_SCHEDULER.DISABLE('PURGE_LOG');

SQL> EXEC DBMS_SCHEDULER.DISABLE('FGR$AUTOPURGE_JOB');

SQL> EXEC DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');

SQL> EXEC DBMS_SCHEDULER.DISABLE('AUTO_SPACE_ADVISOR_JOB');

 

 

SQL> SELECT OWNER, JOB_NAME, JOB_CREATOR, STATE FROM DBA_SCHEDULER_JOBS ;

 

OWNER                          JOB_NAME                       JOB_CREATOR                    STATE

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

SYS                            PURGE_LOG                      SYS                            DISABLED

SYS                            FGR$AUTOPURGE_JOB              SYS                            DISABLED

SYS                            GATHER_STATS_JOB               SYS                            DISABLED

SYS                            AUTO_SPACE_ADVISOR_JOB         SYS                            DISABLED