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.