Re: Limitation of Oracle XE

<leo_at_tech-trans.com> wrote in message
news:1162521447.008925.72000_at_h48g2000cwc.googlegroups.com...
> Hi!
>
> What is the maximum number connection of Oracle XE? 10? below 10?
> Thx!
>
> Ming
>

Ming,

You might find this article helpful:
http://www.oracle.com/technology/pub/articles/cunningham-database-xe.html

Excerpt:

The first limitation is memory¡XOracle Database XE can address only 1GB of RAM. But when you consider the relative rarity of machines that offer 1GB of memory (especially in small businesses), this limitation should mainly affect how many users can access the database concurrently and, to a certain degree, how well it will perform when those limits are hit. For most purposes Oracle Database XE will be deployed to a single user desktop or small workgroup server, so 1GB is more than enough.

The second limit is that XE will only use one CPU. That does not mean that it won't multi-task or that it can only perform a single function at a time. Rather, XE will run on a computer with more than one CPU, it just won't scale up to use those CPUs. For that functionality, you need to purchase Oracle Database Standard Edition or Enterprise Edition. Again, for the uses discussed here, one CPU is more than enough.

The third limit is that only a single XE database can run on any given computer. The important point here is that you don't need a database for each application you create, as you might for some competing databases. Instead, Oracle uses the concept of schemas to separate applications. Received on Thu Nov 02 2006 - 21:17:07 CST