 |
|
Oracle Processes Parameter Tips
Oracle Tips by Burleson Consulting
July 9, 2009
|
Question: I want to increase the max allowed
number of sessions so I am going to increase the number of processes
from 150 to 200.
Do I need to change any other parameter value or simply
I need to run the query (alter system set processes=200
scope=spfile;)?
What else besides sessions is controlled by
the processes parameter?
Answer:
You are correct that the processes
parameter controls the number of allowed Oracle sessions, but the processes
parameter also has "derivatives" parameters that are controlled by the value
of the processes parameter. These derived parameters include
sessions, enqueue_resources,
and _enqueue_hash_chains.
See here on how to
change an initialization parameter.
