创建JOB每天收集AB13表的统计信息

CREATE OR REPLACE PROCEDURE GATHER_AB13  IS

  BEGIN
    DBMS_STATS.GATHER_TABLE_STATS(OWNNAME          => 'NCSI',
                                  TABNAME          => 'AB13',
                                  ESTIMATE_PERCENT => 100,
                                  METHOD_OPT       => 'FOR ALL COLUMNS SIZE AUTO',
                                  DEGREE           => 2,
                                  CASCADE          => TRUE);

END GATHER_AB13;

创建过程。

BEGIN

  DBMS_SCHEDULER.CREATE_JOB(
                           
                            JOB_NAME => 'GATHER_STATISTICS_AB13',
                           
                            JOB_TYPE => 'STORED_PROCEDURE',
                           
                            JOB_ACTION => 'GATHER_AB13',
                           
                            START_DATE => TO_DATE('14-07-2010 17:36:38',
                                                  'dd-mm-yyyy hh24:mi:ss'),
                           
                            REPEAT_INTERVAL => 'FREQ=DAILY;INTERVAL=1');

END;

创建JOB。

exec dbms_scheduler.enable('GATHER_STATISTICS_AB13');

激活JOB。

 

这个JOB每天的17:36会执行了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22034023/viewspace-668016/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22034023/viewspace-668016/