Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Which oracle server ?

Re: Which oracle server ?

From: HansF <News.Hans_at_telus.net>
Date: Wed, 08 Dec 2004 17:05:46 GMT
Message-Id: <pan.2004.12.08.17.06.03.395518@telus.net>


On Wed, 08 Dec 2004 11:40:14 -0500, Murtix Van Basten wrote:

> Hi all,
>
> I will deploy a database project to an Oracle server, but I could not
> figure out which version of Oracle should I get. Here is my configuration:
> Hardware:
> Dell 1750 Dual Xeon 3.2Ghz, 2GB Ram, 3x36GB Hdd on Raid 5
> Operating System: Redhat Linux 9
>
> I will deploy only 1 database for the application. Only 1 DBA will use the
> Oracle server when necessary. When the database once deployed, Only 1
> application will reach it to read and write data. There will not be any
> other database in the server. The server will be used for only this purpose,
> nothing else.
>
> From Oracle's website, I see there are Enterprise, Standard and Standard One
> level of purchasing options. In this case, which should I go with ?
>
> Thank you for answers.
>
> Murtix Van Basten.

Can't answer you question because I don't know the requirements at the feature level. The following should help you decide for yourself...

  1. Standard Edition One (SE1) is effectively the same as STandard Edition, but limited to a single machine with one or two CPU.
  2. Standard Edition has a subset of features of the Enterprise Edition and can be installed on any machine with up to 4 CPU.

FOr Oracle Database 10g, this is extended to 'any machine or combination of machines with up to 4 CPU in total across the machines'. Specifically for 10g to accomodate the 'any combination' condition, Standard Edition also permits installation of RAC at no added charge - that is not available with SE1.

3) Enterprise Edition has a large number of scalability and high availability (and a few functionality) capabilities not found in Standard Edition. These are documented in the New Features document for each database version.

If you need any features that are marked as 'Enterprise Edition', you need that edition. Based on a message in this forum a few months back, all other features are included in Standard.

Which Version? Personal opinion - I recommend 10g.

3) Enterprise Edition has a large number of scalability and high availability (and a few functionality) capabilities not found in Standard Edition. These are documented in the New Features document for each database version. If you need any features that are marked as 'Enterprise Edition', you need that edition. Based on a message in this forum a few months back, all other features are included in Standard.

Which Version? Personal opinion - I recommend 10g. I note your comment about 'only one application will ...'. Be aware that Oracle licenses by CPU _or_ by 'named user "plus"'. Named User is literally the name of an end user accessing the application, so a database handling 10 users but having only one user logged on to the DB (multiplex, or other) would still be 10 named users. License by CPU is equiv to unlimited users.

HTH
/Hans Received on Wed Dec 08 2004 - 11:05:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US