Shulou(Shulou.com)06/01 Report--

Environment:

OS:Centos 7.5

DB:Oracle 11.2.0.4.0 single instance

Scenario 1: job does not start, stop the library, and after starting the library again, the time to start the library is the start time of job, and start running job automatically, and will not automatically make up for the job missed during the shutdown period. Scenario 2: when the job is halfway running, the library is stopped. After starting the library again, the starting time of the database is the running time of job. The job execution of half of the execution before stopping the library will not continue, and the execution of job will start again. Scenario 3: before stopping the library, set the job_queue_processes parameter to 0, the running job will continue to run and complete, and the subsequent job will not run automatically. Change the job_queue_processes parameter back to 1000 and the job will start running.

Values for job_queue_processes range from 0 to 1000

When the value is set to 0, job created in any way will not run.

When the value is set to be greater than 1, and the job is executed in parallel, at least one is a coordination process. The total does not exceed the value of job_queue_processes.

The experimental process is as follows:

Create test data

-sysSQL > grant execute on DBMS_LOCK to cjc;---cjcSQL > create table T1 (id number,itime varchar2); SQL > CREATE OR REPLACE PROCEDURE test_pro isbegin for i in 1. 10 loop insert into T1 values (I, to_char (sysdate, 'yyyy/mm/dd hh34:mi:ss')); DBMS_LOCK.SLEEP (10); commit; end loop;end;/SQL > exec test_pro;PL/SQL procedure successfully completed.Elapsed: 0001 to_char 40.09

Create job

SQL > declare job_id pls_integer;begin sys.dbms_job.submit (job = > job_id, what = > 'test_pro ', next_date = > to_date (' 2020-07-02 22 yyyy-mm-dd hh34:mi:ss'), interval = > 'TRUNC (sysdate,''mi'') + 3 / (24 * 60)'; commit;end;/

Scene 1: job does not start, stop the library

Select job, schema_user, last_date, this_date, next_date, interval from dba_jobs where schema_user = 'CJC';JOBSCHEMA_USERLAST_DATETHIS_DATENEXT_DATEINTERVAL123CJC2020/7/2 22 last_date 52 select job 142020 startupselect 2 22:55:00TRUNC (sysdate,'mi') + 3 / (24 * 60) 22:54SQL > shutdown immediate22:56SQL > startupselect * from dba_jobs_running SIDJOBFAILURESLAST_DATELAST_SECTHIS_DATETHIS_SECINSTANCE1292302020/7/2 22 select job 52 schema_user, last_date, this_date, next_date, interval from dba_jobs where schema_user = 'CJC' JOBSCHEMA_USERLAST_DATETHIS_DATE NEXT_DATE INTERVAL123CJC2020/7/2 22 sysdate,'mi' 52 SQL 1420 from T1; COUNT (*)-10

Scenario 2: halfway through job execution, stop the library

Select job, schema_user, last_date, this_date, next_date, interval from dba_jobs where schema_user = 'CJC'; JOBSCHEMA_USERLAST_DATETHIS_DATENEXT_DATEINTERVAL123CJC2020/7/2 2256 22:59:0022:59:000SQL 2420 22:59:0022:59:000SQL > select count (*) from T1 7 22:59:0022:59:000SQL > select count (*) from T1 COUNT (*)-1222 shutdown immediate23:00SQL 59 SQL > shutdown immediate23:00SQL > startupselect * from dba_jobs_running SIDJOBFAILURESLAST_DATELAST_SECTHIS_DATETHIS_SECINSTANCE1302302020/7/2 22 22 shutdown immediate23:00SQL 56 24 22 15 56 shutdown immediate23:00SQL 24 20 20 A 7 23:00:3323:00:330select job, schema_user, last_date, this_date, next_date, interval from dba_jobs where schema_user = 'CJC' JOBSCHEMA_USERLAST_DATETHIS_DATENEXT_DATEINTERVAL123CJC2020/7/2 22 sysdate,'mi' 56 SQL 2420 COUNT 7 COUNT (*)-24)-24

Scenario 3: adjust job_queue_processes parameters

SQL > show parameter job_queue_processesSQL > select * from dba_jobs_running;SQL > alter system set job_queue_processes=0;SQL > select * from dba_jobs_running;SQL > alter system set job_queue_processes=1000;SQL > select * from dba_jobs_running;SQL > select count (*) from T1

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.