Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I change the maximum number of connection to Oracle database at start? I use :

ALter system set sessions=500 scope=spfile; 

However, after restart the database, use show parameter sessions still give value 772 for sessions


share|improve this question

are you also changing PROCESSES parameter afterwards? sessions is a derived parameter.

Try changing sessions last?

share|improve this answer
Hi Nick, Thanks for your help. I only changed the sessions param. And I get the output 'system altered' after that. – Khue Vu Jul 22 '10 at 8:54
Hi Nick, I find the answer to this. I lowered down the processes parameter and then the sessions parameter is changed. I guess we can set sessions below a certain threshold regarding processes. – Khue Vu Jul 22 '10 at 9:13
what version or oracle? – Nick Kavadias Jul 23 '10 at 0:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.