创建存储过程
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);
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;