통계수집 관련 SCHEDULER_JOB disable

oracle 통계수집 SCHEDULER_JOB disable 시키기

 - Disable -   

            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;
            / 

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

확인 쿼리

select client_name,status from Dba_Autotask_Client;