Re: XE/SE/SE1/EE Options (again)
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: brian.x.wisniewski@xxxxxxxxxxxx
- Date: Mon, 10 Apr 2006 19:51:21 +0200
Just speculating... I assume that SE should start on any node with any
number of CPUs based on the fact that Oracle does not really enforce
licensing in that way but rather leave it to the customer to adhere to the
contract.
2006/4/10, brian.x.wisniewski@xxxxxxxxxxxx <brian.x.wisniewski@xxxxxxxxxxxx
>:
>
>
> Having never run SE this may be a non-issue but... Does SE limit you on
> how many processors are 'presented' to the database vs you doing the
> calculation? Will SE even start up if the O/S is presenting '8' dual-core
> cpu's, probably changing cpu_count would fix it but does SE have these types
> of limitations? ORA- Error msg to the alert log? No idea. I'm not sure
> how the dual-cores present themselves - no access to that either :-(
>
> Just some additional thoughts about SE above and beyond the legal
> definitions.
>
> *
> * <http://www.jpmorganchase.com/>
> Brian S. Wisniewski
> Sr. Oracle Database Administrator
> Central Technology Infrastructure & Operations
> brian.x.wisniewski@xxxxxxxxxxxx
> Cell: 614.975.2905
>
>
>
> *"Niall Litchfield" <niall.litchfield@xxxxxxxxx>*
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>
> 04/10/2006 01:32 AM
> Please respond to niall.litchfield
>
> To: Rich.Jesse@xxxxxx
> cc: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
> Subject: Re: XE/SE/SE1/EE Options (again)
>
>
> Hi Jesse
>
> On 4/7/06, *Jesse, Rich* <*Rich.Jesse@xxxxxx* <Rich.Jesse@xxxxxx>> wrote:
> Hey all,
>
> I'm looking at
> *http://www.oracle.com/database/product_editions.html*<http://www.oracle.com/database/product_editions.html>to
> get the differences between the Oracle editions (okay, I'm not really
> looking at XE). There's a "Oracle Database 10g Product Family white
> paper" PDF on that page that lists SE as not having "Comprehensive
> online schema reorganization/redefinition", but for the life of me I
> can't find what actual Oracle pieces that would include.
>
>
> you can't do online maintenance operations in SE so no 'ALTER INDEX ....
> REBUILD ONLINE', 'ALTER TABLE ... MOVE ... ONLINE' etc. I imagine the
> redefinition package isn't available - but you can be sure I'll see a bit
> later today.
>
>
>
> Also, since SE is limited "to four processors", does that mean I could
> only legally run two 8-core SPARC T1s?
>
> Thoughts?
>
> It appears so, somewhat surprisingly to me. From the licensing definitions
>
> "*Processor:* shall be defined as all processors where the Oracle programs
> are installed and/or running. Programs licensed on a processor basis may be
> accessed by your internal users (including agents and contractors) and by
> your third party users. For the purpose of counting the number of processors
> which require licensing for a Sun UltraSPARC T1 processor with 4, 6 or 8
> cores at 1.0 gigahertz or 8 cores at 1.2 gigahertz for only those servers
> specified on the Sun Server Table which can be accessed at
> *http://oracle.com/contracts
> * <http://oracle.com/contracts>, "n" cores shall be determined by
> multiplying the total number of cores by a factor of .25. For the purposes
> of counting the number of processors which require licensing for AMD and
> Intel multicore chips, "n" cores shall be determined by multiplying the
> total number of cores by a factor of .50. For the purposes of counting the
> number of processors which require licensing for all hardware platforms not
> otherwise specified in this section, a multicore chip with "n" cores shall
> be determined by multiplying "n" cores by a factor of .75. All cores on all
> multicore chips for each licensed program for each factor listed below are
> to be aggregated before multiplying by the appropriate factor and all
> fractions of a number are to be rounded up to the next whole number.
> Notwithstanding the above, when licensing Oracle Standard Edition One or
> Standard Edition programs on servers with a maximum of 1 processor with 1 or
> 2 cores, only 1 processor shall be counted."
>
> So I reckon 16 SUN T1 cores equates exactly to 4 processors. whereas 16
> AMD cores equates to 8 processors. I'm not going to comment on what I think
> of the licensing scheme itself here, since this is a family list an' all.
>
> TIA,
> Rich
> --*
> **//www.freelists.org/webpage/oracle-l
> *<//www.freelists.org/webpage/oracle-l>
>
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA*
> **http://www.orawin.info* <http://www.orawin.info/>
>
--
Best regards,
Alex Gorbachev
Other related posts:
