Change Number of Oracle Sessions and Processes

HashFlare

Change Number of Oracle Sessions and Processes

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

 

Back to previous menu