6.8 Controlling the Number of Concurrent Jobs

Learn about specifying the number of concurrently running jobs.

6.8.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.

6.8.2 Viewing the Number of JOB_QUEUE_PROCESSES

You can view number of JOB_QUEUE_PROCESSES in three ways.

6.8.2.1 Viewing JOB_QUEUE_PROCESSES in the Installation Log File

Learn how to view the JOB_QUEUE_PROCESSES in the installation log files.

6.8.2.2 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:

  1. Sign in to Oracle Application Express.
  2. Locate the Help menu at the top of the page.
  3. From the Help menu, select About.

    The About Application Express page appears. The current number JOB_QUEUE_PROCESSES displays at the bottom of the page.

6.8.2.3 Viewing JOB_QUEUE_PROCESSES from SQL*Plus

Learn how to view the number of JOB_QUEUE_PROCESSES from SQL*Plus by running the following SQL statement.

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

6.8.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 JOB_QUEUE_PROCESSES:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:
    • On Windows:

      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
      
  2. 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 = 20 sets JOB_QUEUE_PROCESSES to 20.