DBMS_JOB.SUBMIT 困惑

lingzhiluoye

oracle 官档版本 Oracle® Database PL/SQL Packages and Types Reference 10g Release 2 (10.2)

请问 ：instance 、force  参数 含义



个人理解            

       instance  指定是  select instance_number  from v$instance;

force   默认 FALSE ， 代表当前instance 运行 ； 若为 TRUE   代表 在 instance参数 指定的 instance_number   上运行

xin_chy

instance
When a job is submitted, specifies which instance can run the job.
force
If this is TRUE, then any positive integer is acceptable as the job instance. If this is FALSE (the default), then the specified instance must be running; otherwise the routine raises an exception.
Usage Notes
The parameters instance and force are added for job queue affinity. Job queue affinity gives users the ability to indicate whether a particular instance or any instance can run a submitted job.

lingzhiluoye

xin_chy 发表于 2012-12-18 15:33
instance
When a job is submitted, specifies which instance can run the job.
force

英文看过，不是很明白

lingzhiluoye

明白大概意思，想设计个实验，但是测试目的不明确，不知道如何下手

Liu Maclean(刘相兵

force
If this is TRUE, then any positive integer is acceptable as the job instance. If this is FALSE (the default), then the specified instance must be running; otherwise the routine raises an exception.


==》 没有具体测试过， 就说明来看

FALSE 默认， 执行的实例必须运行中，否则该JOB报错
TRUE ，任何正整数实例号皆可