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.

Related: https://stackoverflow.com/questions/20742794/ora-12516-tnslistener-could-not-find-available-handler — AlikElzin-kilaka, Nov 21 '19 at 11:45

score 3 · Answer 1 · answered Jul 22 '10 at 08:38

3

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

Try changing sessions last?

answered Jul 22 '10 at 08:38

Nick Kavadias

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 08: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 09:13
what version or oracle? – Nick Kavadias Jul 23 '10 at 00:40
This answer sounds more like a comment. – AlikElzin-kilaka Nov 21 '19 at 11:07

AlikElzin-kilaka · Answer 2 · 2019-11-21T13:04:23.603

Change:

echo "alter system set processes=1000 scope=spfile;" | sqlplus system/password@localhost:1521/orcl

echo "alter system set sessions=1000 scope=spfile;" | sqlplus system/password@localhost:1521/orcl
Restart DB
Check:

echo "SELECT value FROM v\$parameter WHERE name = 'processes';" | sqlplus system/password@localhost:1521/orcl

echo "SELECT value FROM v\$parameter WHERE name = 'sessions';" | sqlplus system/password@localhost:1521/orcl

2 Answers2