Re: oracle 7.3 and windows 2000 server SP4

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/cd/B25329_01/doc/license.102/b25456/toc.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. ***