Re: XE/SE/SE1/EE Options (again)

  • From: brian.x.wisniewski@xxxxxxxxxxxx
  • To: niall.litchfield@xxxxxxxxx
  • Date: Mon, 10 Apr 2006 12:49:40 -0400

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.



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> wrote:
Hey all,

I'm looking at 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 , "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 





-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info 

GIF image

Other related posts: