Adjust session, process and memory parameters for Oracle XE after install

xe_post_install_optimize.sql

-- run as SYS
sqlplus /nolog
connect sys as sysdba

-- show current values
show parameters sessions;
show parameters processes;
show parameters memory;

-- adjust values 
alter system set sessions=250 scope=spfile;
alter system set processes=200 scope=spfile;
-- note: make sure there is enough shared memory space (tmpfs) before increasing database memory parameters
--       see "Scaling up and down the server" for separate script to adjust tmpfs size
alter system set memory_target=1024M scope=spfile;
alter system set memory_max_target=1024M scope=spfile;

-- restart database
shutdown immediate;
startup;