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
show parameters processes;
alter system set processes=200
sudo /etc/init.d/oracle-xe restart

No comments:

Post a Comment