Init parameterProcesses & sessions

JOB_QUEUE_PROCESSES

What it controls

The most job slave processes for Scheduler and DBMS_JOB jobs.

Know this before you change it

Setting it to 0 stops all scheduled jobs, which is useful during upgrades and maintenance. Write down the old value first so you can put it back.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'job_queue_processes';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'job_queue_processes' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET job_queue_processes = 80 SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET job_queue_processes SCOPE = SPFILE SID = '*';

Related scripts

• Scheduler jobs running nowJobs currently executing, the session running each one and how long it has been going.
• Application scheduler jobs and next runNon-Oracle scheduler jobs with their state, last and next run, and failure count. Disabled or BROKEN jobs stand out at a glance.

Open in the parameter referenceOracle's reference

More in Processes & sessions

• PROCESSESThe most operating system processes that can connect to the instance, including background processes.
• SESSIONSThe most sessions the instance allows.
• OPEN_CURSORSThe most cursors one session can have open at once.
• SESSION_CACHED_CURSORSHow many closed cursors each session keeps cached, which saves repeated soft parses.
• RESOURCE_LIMITWhether profile resource limits such as idle time and CPU per call are enforced.
• DDL_LOCK_TIMEOUTSeconds a DDL statement waits for a lock before failing with ORA-00054.