Memory sizing, increasing number of processes
Hello everyone,
We recently ran in to the trouble of our Oracle Database (10.2.0.2) didn't allow more OS processes to connect to to.
IE, the number set in the processes parameter was reached.
Now before I want to increase the parameter I wonder if I also have to increase the memory pool Oracle has to work with.
Is there a formula for calculating this?
I guess you have to increase the number of session if you change the processes parameter to reflect the fact that the max number of sessions is nr of processes * 1.1 + 5 (If I got that formula correct)
I would very much appriciate if someone could shed some light over this for me.
We recently ran in to the trouble of our Oracle Database (10.2.0.2) didn't allow more OS processes to connect to to.
IE, the number set in the processes parameter was reached.
Now before I want to increase the parameter I wonder if I also have to increase the memory pool Oracle has to work with.
Is there a formula for calculating this?
I guess you have to increase the number of session if you change the processes parameter to reflect the fact that the max number of sessions is nr of processes * 1.1 + 5 (If I got that formula correct)
I would very much appriciate if someone could shed some light over this for me.
0