You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for JOB_QUEUE_PROCESSES


1 to 20 of 78 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

JOB_QUEUE_PROCESSES

1.126 JOB_QUEUE_PROCESSESvalues. JOB_QUEUE_PROCESSES specifies the maximum number of job slaves per instance that can be created … JOB_QUEUE_PROCESSES parameter. If the value of JOB_QUEUE_PROCESSES is set to 0, then DBMS_JOB jobs and … Oracle Scheduler jobs will not run on the instance. If JOB_QUEUE_PROCESSES is set to a value in the

Database Upgrade Guide, 12c Release 1 (12.1)

Changes for Earlier Releases of Oracle Database

A.2.23 JOB_QUEUE_PROCESSES Parameter New Default SettingBeginning with Oracle Database 11 g Release 1 (11.1), the JOB_QUEUE_PROCESSES parameter is changed … matter what JOB_QUEUE_PROCESSES is set to in UPGRADE mode. See Also: Oracle Database Reference for more information on this parameter

Database Upgrade Guide, 12c Release 1 (12.1)

Changes for Earlier Releases of Oracle Database

A.1.3 JOB_QUEUE_PROCESSES Parameter and Scheduling JobsStarting with Oracle Database 11 g Release 2 (11.2), setting JOB_QUEUE_PROCESSES to 0 causes both … DBMS_SCHEDULER and DBMS_JOB jobs to not run. Previously, setting JOB_QUEUE_PROCESSES to 0 caused … scheduler). It does not matter what JOB_QUEUE_PROCESSES is set to in UPGRADE mode. See Also: Oracle Database Reference for more information

Services for Microsoft Transaction Server Developer's Guide for Microsoft Windows, 12c Release 1 (12.1)

Glossary

JOB_QUEUE_PROCESSESThis initialization parameter specifies the maximum number of DBMS_JOB jobs and Oracle Scheduler ( DBMS_SCHEDULER ) jobs running concurrently on an instance. This parameter must be set to at least 1 to run Oracle Scheduler or DBMS_JOB jobs and to use database features that depend on these jobs

Database Administrator's Guide, 12c Release 1 (12.1)

Support for DBMS_JOB

A.1.1 Configuring DBMS_JOBThe JOB_QUEUE_PROCESSES initialization parameter specifies the maximum number of processes that can … be created for the execution of jobs. Beginning with Oracle Database 11 g, JOB_QUEUE_PROCESSES … , based on the number of jobs to run and available resources. You can set JOB_QUEUE_PROCESSES to a … lower number to limit the number

Database Administrator's Guide, 12c Release 1 (12.1)

Support for DBMS_JOB

A.1.2 Using Both DBMS_JOB and Oracle Schedulercan use the JOB_QUEUE_PROCESSES initialization parameter to limit the number job slaves for both … DBMS_JOB and the Scheduler. If JOB_QUEUE_PROCESSES is 0, both DBMS_JOB and Oracle Scheduler jobs are … Database Reference for more information about the JOB_QUEUE_PROCESSES initialization parameter

Application Express Installation Guide for Oracle Database 12c, 12c Release 1 (12.1)

Configuration Tasks When Installing from the Database

4.4.7 About Managing JOB_QUEUE_PROCESSESJOB_QUEUE_PROCESSES determine the maximum number of concurrently running jobs. In Oracle … Application Express release 4.2, transactional support and SQL scripts require jobs. If JOB_QUEUE_PROCESSES is … JOB_QUEUE_PROCESSES Changing the Number of JOB_QUEUE_PROCESSES 4.4.7.1 Viewing the Number of … JOB_QUEUE_PROCESSES

Application Express Installation Guide for Oracle Database 12c, 12c Release 1 (12.1)

Configuration Tasks When Installing from the Database

4.5.7 About Managing JOB_QUEUE_PROCESSESJOB_QUEUE_PROCESSES determine the maximum number of concurrently running jobs. In Oracle … Application Express release 4.2, transactional support and SQL scripts require jobs. If JOB_QUEUE_PROCESSES is … JOB_QUEUE_PROCESSES Changing the Number of JOB_QUEUE_PROCESSES 4.5.7.1 Viewing the Number of … JOB_QUEUE_PROCESSES

Application Express Installation Guide for Oracle Database 12c, 12c Release 1 (12.1)

Configuration Tasks When Installing from the Database

4.6.6 About Managing JOB_QUEUE_PROCESSESJOB_QUEUE_PROCESSES determine the maximum number of concurrently running jobs. In Oracle … Application Express release 4.2, transactional support and SQL scripts require jobs. If JOB_QUEUE_PROCESSES is … JOB_QUEUE_PROCESSES Changing the Number of JOB_QUEUE_PROCESSES 4.6.6.1 Viewing the Number of … JOB_QUEUE_PROCESSES

Database Administrator's Guide, 12c Release 1 (12.1)

Oracle Scheduler Concepts

28.4.4 How Jobs Executemany job slaves to start based on CPU load and the number of outstanding jobs. The JOB_QUEUE_PROCESSES … . See Also: Oracle Database Reference for more information about the JOB_QUEUE_PROCESSES

Database Administrator's Guide, 12c Release 1 (12.1)

Using Oracle Scheduler with a CDB

46.1 DBMS_SCHEDULER Invocations in a CDBscheduler global attributes. To limit job slaves, set the value of the job_queue_processes

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Oracle Scheduler the Scheduler enables database administrators and application developers to control…… The initialization parameter JOB_QUEUE_PROCESSES represents the maximum number of job queue … initialization parameter JOB_QUEUE_PROCESSES is set to 0. See Also: \" Oracle Scheduler \" Oracle

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

UTL_RECOMP

Examplesof threads specified in the parameter JOB_QUEUE_PROCESSES: EXECUTE UTL_RECOMP.RECOMP_PARALLEL(NULL, 'JOE');

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_PCLXUTIL

Operational Notesthe number of concurrent jobs by setting the INIT. ORA parameter JOB_QUEUE_PROCESSES correctly

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_PCLXUTIL

Rules and Limitsvalues for the job_queue_processes initialization parameter. Clearly, if the job processes are not … processes are specified by the following init. ora parameters: job_queue_processes=n #the number of

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing Optimizer Statistics: Basic Topics

You can monitor statistics gathering jobs using data dictionary views.tablespace. The JOB_QUEUE_PROCESSES initialization parameter must be set to at least 4. The Resource … SYSTEM SET RESOURCE_MANAGER_PLAN = 'DEFAULT_PLAN'; Set the JOB_QUEUE_PROCESSES initialization … JOB_QUEUE_PROCESSES setting applies to each node. Assume that the system has 4 CPU cores. The following example … sets the parameter

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_QOPATCH

Operational Notesother node(s) to get the data. In this case JOB_QUEUE_PROCESSES needs to be >0 for the package to fetch

Database Upgrade Guide, 12c Release 1 (12.1)

Changes for Earlier Releases of Oracle Database

A.1.12 Deprecated Features in Oracle Database 11g Release 2 (11.2)… MAX_JOB_SLAVE_PROCESSES MAX_JOB_SLAVE_PROCESSES has been deprecated. Use JOB_QUEUE_PROCESSES instead.

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing Optimizer Statistics: Basic Topics

To enable concurrent statistics gathering, use the DBMS_STATS.SET_GLOBAL_PREFS procedure to set the…jobs is bounded by the JOB_QUEUE_PROCESSES initialization parameter and available system resources. In … Reference to learn about the JOB_QUEUE_PROCESSES initialization parameter

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_QOPATCH

Error Messagesexecuted. ORA-20011 Job name is NULL and inventory cannot be loaded. ORA-20012 JOB_QUEUE_PROCESSES is