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 limit the amount of concurrent connections (for example, the number of users viewing the site)?
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.