Re: Limitation of Oracle XE

Jonathan Roberts wrote:
> <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.

That is a helpful link, which implied that the maximum number of connections is operating system dependent. Microsoft's desktop operating systems, including Windows NT 4, Windows 2000, and Windows XP have a built in maximum - up to 10 network devices can simultaneously be connected to computers running those operating systems. The limitation is designed to discourage people from using a desktop operating system (with no per connected client charge) as a server, rather than using a server operating system (with a per connected client charge). Computers with Windows XP Service Pack 2 are more aggressive in limiting network connections, and emit an entry in the event log when the limit has been exceeded. Gone are the days of using a Windows 95 box acting as a file server with 50+ other computers connected to it.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Nov 02 2006 - 21:36:27 CST