Wednesday 3 December 2008

oracle XE sessions and processes

I found that my locally installed Oracle XE runs out of available connections far too soon for a php app I'm running. This results in some weird gui behaviour: some frames just don't load. Fortunately I found a way to sort of makes it a little better:

sqlplus system@XE
show parameters sessions;
alter system set sessions=250
scope=spfile;
show parameters processes;
alter system set processes=200
scope=spfile;
sudo /etc/init.d/oracle-xe restart

http://www.markcallen.com/oracle/oracle-xe-tuning

No comments:

Post a Comment