DBMS/Oracle
Oracle 자동 통계 수집 중지 하기
DB 전체 자동 통계 중지 BEGIN DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB'); END; / PL/SQL procedure successfully completed. col SCHEDULE_NAME for a40 select job_name, enabled, SCHEDULE_NAME, STATE from dba_SCHEDULER_JOBs ; JOB_NAME ENABL SCHEDULE_NAME STATE ------------------------------ ----- ------------------------------ ------------------- AUTO_SPACE_ADVISOR_JOB TRUE MAINTENANCE_WINDOW_GROUP SCHEDULED ..
