Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

Khue.

share|improve this question

1 Answer 1

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

 
discard

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.