| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-03 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-03 |
|
|
View PDF |
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 100 |
| 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:
Oracle Database Administrator's Guide for information on setting this parameter in exclusive mode
Oracle Real Application Clusters Administration and Deployment Guide for information on setting this parameter in an Oracle RAC environment
Your operating system-specific Oracle documentation for the range of values
|
 Copyright © 2002, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
