Learn about specifying the number of concurrently running jobs.
4.9.1 About Managing the Number of Concurrent 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.
4.9.2 Viewing the Number of JOB_QUEUE_PROCESSES
You can view number of
JOB_QUEUE_PROCESSES in three ways.
188.8.131.52 Viewing JOB_QUEUE_PROCESSES in the Installation Log File
Learn how to view the
JOB_QUEUE_PROCESSES in the installation log files.
184.108.40.206 Viewing JOB_QUEUE_PROCESSES in Oracle Application Express
Learn how to view the number of
JOB_QUEUE_PROCESSES on the About page in Application Express.
To view the About Application Express page:
- Sign in to Oracle Application Express.
- Locate the Help menu at the top of the page.
- From the Help menu, select About.
The About Application Express page appears. The current number
JOB_QUEUE_PROCESSESdisplays at the bottom of the page.
4.9.3 Changing the Number of JOB_QUEUE_PROCESSES
You can change the number of
JOB_QUEUE_PROCESSES by running a SQL statement in SQL*Plus.
To update the number of
- Start SQL*Plus and connect to the database where Oracle Application Express is installed as
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
- In SQL*Plus run the following SQL statement:
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = <number>
For example, running the statement
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20sets