Learn about specifying the number of concurrently running jobs.
Learn about managing maximum number of concurrently running jobs.
JOB_QUEUE_PROCESSES determine the maximum number of concurrently running jobs. In Oracle Application Express transactional support and SQL scripts require jobs. If
JOB_QUEUE_PROCESSES is not enabled and working properly, you cannot successfully execute a script.
You can view number of
JOB_QUEUE_PROCESSES in three ways.
Learn how to view the
JOB_QUEUE_PROCESSES in the installation log files.
Learn how to view the number of
JOB_QUEUE_PROCESSES on the About page in Application Express.
To view the About Application Express page:
The About Application Express page appears. The current number
JOB_QUEUE_PROCESSES displays at the bottom of the page.
You can change the number of
JOB_QUEUE_PROCESSES by running a SQL statement in SQL*Plus.
To update the number of
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
On UNIX and Linux:
$ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = <number>
For example, running the statement
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20 sets
JOB_QUEUE_PROCESSES to 20.