Warning: PROCESSES may be too low for current load
Hello,
I have 64 bit centOS Server and have oracle 10g installed on it.
We have 8GB RAM and 64 bit Server but we were able to install oracle on 2GB SGA only.
From few days I am facing following error:
Warning: PROCESSES may be too low for current load
shared servers=114, want 8 more but starting only 1 more
Warning: PROCESSES may be too low for current load
shared servers=114, want 8 more but starting only 1 more
Warning: PROCESSES may be too low for current load
shared servers=115, want 8 more but starting only 0 more
I have executed following commands:
ALTER SYSTEM SET max_shared_servers=200 SCOPE=MEMORY;
ALTER SYSTEM SET circuits=300 SCOPE=MEMORY;
But I am still getting the same error,and server average load goes too high and needs a oracle restart.
Please let me know in case any one has solution for this problem. Its urgent.
Thanks in Advance.