Re: Limitation of Oracle XE

From: bernard (bernard_at_bosvark.com) <bernard_at_bosvark.com>
Date: 3 Nov 2006 02:06:41 -0800
Message-ID: <1162548401.090628.131820@h48g2000cwc.googlegroups.com>

> What is the maximum number connection of Oracle XE? 10? below 10?
> Thx!

One of our Java developers claimed he could not open a connection pool
> 15 sessions on hist local XE database. The following parameter changes fixed the limited number of connection but I was too lazy to check which one fixed the problem. Have fun:

alter system set session_cached_cursors=100 scope=spfile; alter system set session_max_open_files=100 scope=spfile; alter system set sessions=10 scope=spfile; alter system set license_max_sessions=100 scope=spfile; alter system set license_sessions_warning=100 scope=spfile; alter system set processes=100 scope=spfile;

Regards
Bernard Received on Fri Nov 03 2006 - 04:06:41 CST