- 论坛徽章:
- 0
|
[help] dbms_job包问题
job_queue_process最大只能36,指定将由oracle实例启动的snp后台进程树木
job_queue_internal:
In addition to defining the number of job processes, you must also define the job interval. The job interval determines how often your job processes "wake up" to execute any pending operations, such as pushing a queue. While the default value of 60 seconds is adequate for most replicated environments, you may need to adjust this value to maximize performance for you individual requirements. For example, if you want to propagate changes every 20 seconds, a job interval of 60 seconds would not be sufficient. On the other hand, if you need to propagate your changes once a day, you may only want your SNP process to check for a pending operation once an hour. |
|