Learn about specifying the number of concurrently running jobs.
JOB_QUEUE_PROCESSES
in three ways.JOB_QUEUE_PROCESSES
by running a SQL statement in SQL*Plus.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.
Parent topic: Controlling the Number of Concurrent Jobs
You can view number of JOB_QUEUE_PROCESSES
in three ways.
JOB_QUEUE_PROCESSES
in the installation log files.JOB_QUEUE_PROCESSES
on the About page in Application Express.JOB_QUEUE_PROCESSES
from SQL*Plus by running the following SQL statement.Parent topic: Controlling the Number of Concurrent Jobs
Learn how to view the JOB_QUEUE_PROCESSES
in the installation log files.
See Also:
Parent topic: Viewing the Number of JOB_QUEUE_PROCESSES
Learn how to view the number of JOB_QUEUE_PROCESSES
on the About page in Application Express.
To view the About Application Express page:
Parent topic: Viewing the Number of JOB_QUEUE_PROCESSES
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'
Parent topic: Viewing 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
:
Parent topic: Controlling the Number of Concurrent Jobs