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).
Oracle 9i
Default value for job_queue_processes is "0". so whenever we create any job through dbms_job we have to also modify job_queue_processes parameter > '0'.
job_queue_processes
Oracle 10g
In Oracle 10g Default value for job_queue_processes is "10". so whenever we create any job through dbms_job then we no need to modify job_queue_processes parameter. but in documentation show "0" is default value.
job_queue_processes
No comments:
Post a Comment