Oracle Database 10g Express Edition - Multiple Connections
Have you ever noticed the (apparent) limitation of Oracle Database 10g Express Edition to 10 connections (its a free product). It can be overcome.
This is how it can be done:
Open ‘Run SQL Command Line’
Digit: connect sys as sysdba (fill the password)
execute these commands:
alter system set processes = 200 scope = spfile;
alter system set sessions = 300 scope = spfile;
alter system set transactions = 350 scope = spfile;
restart the database:
shutdown immediate;
startup;
And voilá!
