how to change the maximum number of connection to Oracle database?

Question

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.

Nick Kavadias · Answer 1 · 2010-07-22 08:38:49Z

up vote 2 down vote

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

Try changing sessions last?

answered Jul 22 '10 at 8:38

	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

feedback

1 Answer