On Thu, 09 Mar 2006 21:19:05 +0100, Maxim Demenko wrote:


> Regarding the cpu's - this is from license agreement
>
> http://download-uk.oracle.com/docs/c...c.htm#BABHFGHA
> Any use of the Oracle Database Express Edition is subject to the
> following limitations; 1. Express Edition is limited to a single
> instance on any server; 2. Express Edition may be installed on a
> multiple CPU server, but may only be executed on one processor in any
> server; 3. Express Edition may only be used to support up to 4GB of user
> data (not including Express Edition system data); 4. Express Edition may
> use up to 1 GB RAM of available memory.
>

Those are technical limitations, not license limitations, that Oracle has
imposed on XE. From what I can tell, XE will monitor and enforce those
restrictions by itself.

It will never parallelize operations (single CPU) even if on a
multiple-CPU machine. It will never use more than 1G for the combined
SGA+PGA. It will error out when attempts are made to exceed 4GB *user
data* (non-system tablespaces). The SID/DatabaseName is hard coded as XE
and seems to be checked by the kernel.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***