应用oracle job进行定时统计信息更新

创建存储过程
create or replace procedure JOB_PRO_Gather_Schema_Stats as
begin
dbms_stats.gather_schema_stats(ownname=>'用户名称',estimate_percent=>100,cascade=> TRUE, degree =>6);
end;


创建job //每天凌晨1点执行一次
variable jobGather_Schema_Stats number;
begin
dbms_job.submit(:jobGather_Schema_Stats,'JOB_PRO_Gather_Schema_Stats;',sysdate,'TRUNC(sysdate) + 1 +1/ (24)');
end;


运行job
begin
dbms_job.run(:jobGather_Schema_Stats);

end;

查询job执行情况

select * from dba_jobs

或

select job,last_date,last_sec,next_date,next_sec,broken,failures from dba_jobs;