B.7 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.
• Viewing the Number of JOB_QUEUE_PROCESSES
  You can view number of JOB_QUEUE_PROCESSES in three ways.
• Changing the Number of JOB_QUEUE_PROCESSES
  You can change the number of JOB_QUEUE_PROCESSES by running a SQL statement in SQL*Plus.

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

B.7.2 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
  Learn how to view the JOB_QUEUE_PROCESSES in the installation log files.
• 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.
• 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.

B.7.2.1 Viewing JOB_QUEUE_PROCESSES in the Installation Log File

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

See Also:

"Reviewing a Log of an Installation Session"

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

See Also:

"Signing into a Workspace Using Oracle REST Data Services"

B.7.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'

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