Devoured By Lions

the eternal struggle to tame complexity

Increasing Processes, Sessions and Transactions in Oracle XE

Whenever I set up Oracle XE from scratch for development I always have to hunt this down.

alter system set processes = 150 scope = spfile;
alter system set sessions = 300 scope = spfile;
alter system set transactions = 330 scope = spfile;

http://www.fatlemon.co.uk/2009/06/increasing-processes-sessions-and-transactions-in-oracle-xe/