Oracle XE Tuning

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

Database SessionsIncrease the number of sessions that the database can handle at one time.  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 ProcessesIncrease the number of database processes that can be running at one time.  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.