Are There Any Limitations In Using Oracle Xe?

1.	Are There Any Limitations In Using Oracle Xe?
Answer» XE is free but Oracle has built certain limitations into the product. The first LIMITATION is memory. Oracle Database XE can address only 1GB of RAM. This limitation mainly affects how many users can access the database concurrently and how well it performs. The second limit is that XE will only use one CPU. XE will run on a multi -CPU computer but wont scale up to use those CPUs. This functionality REQUIRES Oracle Database Standard Edition or Enterprise Edition. The third limit is that only a single XE database can run on any given computer. You do not need a database for each application. Instead, Oracle USES the concept of schemas to separate applications. Finally, a 4GB limit is enforced on disk space. 4GB is a huge amount of storage for most applications. You can also use APEX to link to other databases (on other servers) for more storage as needed.

Answer»

XE is free but Oracle has built certain limitations into the product.
The first LIMITATION is memory. Oracle Database XE can address only 1GB of RAM. This limitation mainly affects how many users can access the database concurrently and how well it performs.
The second limit is that XE will only use one CPU. XE will run on a multi -CPU computer but wont scale up to use those CPUs. This functionality REQUIRES Oracle Database Standard Edition or Enterprise Edition.
The third limit is that only a single XE database can run on any given computer. You do not need a database for each application. Instead, Oracle USES the concept of schemas to separate applications.
Finally, a 4GB limit is enforced on disk space. 4GB is a huge amount of storage for most applications. You can also use APEX to link to other databases (on other servers) for more storage as needed.

Discussion