The PROCESSES initialization parameter determines the maximum number of operating system processes that can be connected to Oracle Database concurrently.
cisco certification training courses malaysia
- Set the
PROCESSESinitialization parameter.
ccie certification training courses malaysia
The value of this parameter must be a minimum of one for each background process plus one for each user process. The number of background processes will vary according the database features that you are using. For example, if you are using Advanced Queuing or the file mapping feature, then you will have additional background processes. If you are using Automatic Storage Management, then add three additional processes for the database instance.
ccnp certification training courses malaysia
If you plan on running 50 user processes, a good estimate would be to set the PROCESSES initialization parameter to 70.
Leave a Reply