Oracle XE Tuning

Oracle XE is an excellent starter database, but under typical loads, the out-of-the-box parameters need to be increased.

Database Sessions

Increase the number of sessions that the database can handle simultaneously. This will allow for more users to access the database.

sqlplus /nolog 

SQL> show parameters sessions 
SQL> alter system set sessions=250 scope=spfile;

restart the database.

Database Processes

Increase the number of database processes that can run concurrently. This will allow for more users to connect to the database.

sqlplus /nolog 

SQL> show parameters processes 
SQL> alter system set processes=200 scope=spfile;

restart the database.