the limit of PROCESSES parameter
Hi
We have 16G physical memory. We set sga_target=7904M, sga_max_size=8208M, pga_aggregate_target=1536M.
What I would like to know is:
1. What is the limit to increase the PROCESSES parameter? Before we have to add more memory/hardware or changing to shared server.
2. For now, we set processes=800. If we increase that, what is the impact? Does CPU load will increase to 20-50% or something?
3. What resources that wiil be more consumed by doing this?
What I would like to know is:
1. What is the limit to increase the PROCESSES parameter? Before we have to add more memory/hardware or changing to shared server.
2. For now, we set processes=800. If we increase that, what is the impact? Does CPU load will increase to 20-50% or something?
3. What resources that wiil be more consumed by doing this?
Need kind suggestions
Thanks in advance
2