Performance tuning Oracle XE

By default, Oracle Database XE is tuned to be tiny. Specifically, the system parameter for the number of processes is set to 40 by default and this settting is simply too low. Changing the PROCESSES setting to something larger corrects this bottleneck:

1. Connect to XE as a SYSDBA.
2. In SQL*Plus, enter the following command: alter system set processes=150 scope=spfile;

Below are some additional parameters worth adjusting to increase performance:

• alter system set session_cached_cursors=100 scope=spfile;
• alter system set session_max_open_files=100 scope=spfile;
• alter system set sessions=100 scope=spfile;
• alter system set license_max_sessions=100 scope=spfile;
• alter system set license_sessions_warning=100 scope=spfile;