Controlling the Number of Concurrent Jobs

Learn about specifying the number of concurrently running jobs.

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 APEX transactional support and SQL scripts require jobs. If JOB_QUEUE_PROCESSES is not enabled and working properly, you cannot successfully execute a script.

Viewing the Number of JOB_QUEUE_PROCESSES

You can view number of JOB_QUEUE_PROCESSES in three ways.

Viewing JOB_QUEUE_PROCESSES in the Installation Log File

View JOB_QUEUE_PROCESSES in the installation log files.

See Also: Reviewing a Log of an Installation Session

Viewing JOB_QUEUE_PROCESSES in APEX

View the number of JOB_QUEUE_PROCESSES on the About Oracle APEX page.

To view the About Oracle APEX page:

  1. Sign in to APEX.

  2. Locate the Help menu at the top of the page.

  3. From the Help menu, select About.

    The About APEX page appears.

  4. Scroll down and find JOB_QUEUE_PROCESSES at the bottom of the page.

See Also: Signing In to Your Workspace

Viewing JOB_QUEUE_PROCESSES from SQLcl

View the number of JOB_QUEUE_PROCESSES from SQLcl.

To view the number of JOB_QUEUE_PROCESSES from SQLcl:

  1. Start SQLcl and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role:

    • On Windows:

      <SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

    • On UNIX and Linux:

      $ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

  2. Run the appropriate SQL statement. For example:

    SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes'

Changing the Number of JOB_QUEUE_PROCESSES

You can change the number of JOB_QUEUE_PROCESSES by running a SQL statement in SQLcl.

To update the number of JOB_QUEUE_PROCESSES:

  1. Start SQLcl and connect to the database where Oracle APEX is installed as SYS specifying the SYSDBA role:

    • On Windows:

      <SYSTEM_DRIVE>:\ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

    • On UNIX and Linux:

      $ sql /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: <SYS_password>

  2. In SQLcl run the following SQL statement:

    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.