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

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

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

6.7.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"

6.7.2.2 Viewing JOB_QUEUE_PROCESSES in Oracle 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 Oracle APEX.
2. Locate the Help menu at the top of the page.
3. From the Help menu, select About.

   The About Oracle APEX page appears.

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

See Also:

Signing In to Your Workspace

6.7.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 APEX 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'

6.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 APEX 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.