In this example, let’s change the sessions and processes for 1000
– Connect to the database as an administrator
$ Sqlplus / nolog
SQL> connect / as sysdba
– Change the number of cases for 1000
SQL> alter system set processes = 1000 scope = spfile
– Change the number of sessions for 1000
SQL> alter system set sessions = 1000 scope = spfile
– Stop the database
SQL> shutdown immediate
– Start the database
SQL> startup
To verify that the changes made effect:
SQL> show parameter sessions
SQL> show parameter processes
Note: In the case of Oracle XE, the maximum number of sessions are 20
In this example, let’s change this limitation of 20 sessions to 100 sessions
– Remove the limit of 20 sessions
SQL> alter system reset sessions scope = spfile sid = ‘*’
– Stop the database
SQL> shutdown immediate
– Start the database
SQL> startup