Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

PROCESSES

Property Description
Parameter type Integer
Default value This value is dynamic, and it depends on the number of CPUs. A computation factor of 80 is used for RDBMS instances and for Oracle ASM instances.
Modifiable No
Range of values 6 to operating system dependent
Basic Yes
Oracle RAC Multiple instances can have different values.

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.

The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.

See Also:

  • Your operating system-specific Oracle documentation for the range of values

  • Oracle Database Concepts for an introduction to Oracle database instance processes