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

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

5.9.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
  View JOB_QUEUE_PROCESSES in the installation log files.
• Viewing JOB_QUEUE_PROCESSES in Oracle Application Express
  View the number of JOB_QUEUE_PROCESSES on the About Application Express page.
• Viewing JOB_QUEUE_PROCESSES from SQL*Plus
  View the number of JOB_QUEUE_PROCESSES from SQL*Plus.

5.9.2.1 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"

5.9.2.2 Viewing JOB_QUEUE_PROCESSES in Oracle Application Express

View the number of JOB_QUEUE_PROCESSES on the About Application Express page.

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.

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

See Also:

"Signing into a Workspace Using Oracle REST Data Services"

5.9.2.3 Viewing JOB_QUEUE_PROCESSES from SQL*Plus

View the number of JOB_QUEUE_PROCESSES from SQL*Plus.

To view the number of JOB_QUEUE_PROCESSES from SQL*Plus:

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. Run the appropriate SQL statement. For example:

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

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