Real Application Clusters Multiple instances can have different values. JOB_QUEUE_PROCESSES specifies the maximum number of processes that can be created for the execution of jobs. It specifies the number of job queue processes per instance (J000, ... J999). Replication uses job queues for data refreshes. Advanced queuing uses job queues for message propagation. You can create user job requests through the DBMS_JOB package.Some job queue requests are created automatically. An example is refresh support for materialized views. If you wish to have your materialized views updated automatically, you must set JOB_QUEUE_PROCESSES to a value of one or higher.See Also: Oracle9i Replication and Oracle9i Data Warehousing Guide for more information on managing materialized views Oracle9i Application Developer's Guide - Advanced Queuing for more information on message propagation
job_queue_processes = 4
alter system set job_queue_interval=10
Parameter type
Integer
Default value
0
Parameter class
Dynamic: ALTER SYSTEM
Range of values
0 to 1000
Real Application Clusters
Multiple instances can have different values.
JOB_QUEUE_PROCESSES specifies the maximum number of processes that can be created for the execution of jobs. It specifies the number of job queue processes per instance (J000, ... J999). Replication uses job queues for data refreshes. Advanced queuing uses job queues for message propagation. You can create user job requests through the DBMS_JOB package.Some job queue requests are created automatically. An example is refresh support for materialized views. If you wish to have your materialized views updated automatically, you must set JOB_QUEUE_PROCESSES to a value of one or higher.See Also:
Oracle9i Replication and Oracle9i Data Warehousing Guide for more information on managing materialized views
Oracle9i Application Developer's Guide - Advanced Queuing for more information on message propagation
job_queue_processes = 4 后台启动这么多进程,这些进程的任务就是去唤醒job,但一个可能忙不过来,所以可能多个,每job_queue_interval 秒去检查并唤醒一次明白了么?
为什么大家都不看文挡
看看你的这些job是否需要执行如果不执行它就继续回去睡10秒
需要执行则唤醒job执行自己的任务做一个snapshot就相当于做了一个job