How many connections can Oracle Express Edition (XE) handle?

oracle-xe
Bob picture Bob · May 25, 2009 · Viewed 28.7k times · Source

I'm building a web application that uses Oracle Database 10g as the database backend. I realize the Express edition has limitations, but I just wanted to make sure that number of connections wasn't one of them.

Does Oracle Express Edition (XE) limit the amount of concurrent connections (for example, the number of users viewing the site)?

Answer

LapTop006 picture LapTop006 · May 25, 2009

According to: http://forums.oracle.com/forums/thread.jspa?messageID=1673347 (among others)

There's no hardcoded limit, however there is an effective default limit of ~20 concurrent connections, however you can extend that with something like: ALTER SYSTEM SET processes=200 scope=spfile (and restart the DB)

In practice you've probably either hit other XE limits well before 200 connections, or should have been using a simpler DB to begin with.

Related questions

How to correctly set the ORACLE_HOME variable on Ubuntu 9.x?

I have the same problem as listed here: How to recover or change Oracle sysdba password although I did not lose the password, I entered it twice in the configure script originally, and then when I went to login (localhost:8080/…

Read More
How to create a new database after initally installing oracle database 11g Express Edition?

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well. I want to create a simple database to start with, maybe with one table or two and then use …

Read More
URL string format for connecting to Oracle database with JDBC

I'm a newbie to Java-related web development, and I can't seem to get a simple program with JDBC working. I'm using off-the-shelf Oracle 10g XE and the Eclipse EE IDE. From the books and web pages I've checked so far, …

Read More