"HansF" <News.Hans_at_telus.net> wrote in message
news:pan.2006.03.09.20.32.32.764549_at_telus.net...
> 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. ***
>
system tablespaces being: SYSTEM, TEMP, UNDO ?
--
Terry Dykstra
Canadian Forest Oil Ltd.
Received on Thu Mar 09 2006 - 16:04:17 CST
