Afrikaans
Akan
Albanian
Amharic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
French
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
In this lesson, we'll take a look
at the different editions of the Oracle database
software that are available.
This is an important subject to a DBA,
because the edition your company pays
for will have certain options available, while others
will be excluded.
Also, as a DBA, you need to be able to intelligently determine
which edition is right for your company
so you have all the features you need without overpaying.
To begin, there are two licensing models
available for Oracle database, and they're not
both available for every edition.
The primary way of licensing Oracle software
is the CPU-based model.
That is to say, you license the software
based on the number of CPUs your database server is running.
So let's just make up a few numbers here as an example.
Keep in mind, I'm just making these up for easy math.
How much a company pays for Oracle
can be dependent on a lot of different things,
particularly the size of the contract.
Let's say you've licensed an edition of Oracle that
cost $10,000 per CPU.
If your server has four CPUs, years
that's $40,000 for the license to run the software,
which will include some level of support from Oracle.
However, what if those CPA you are multi-core CPUs?
Will Oracle licensing ignore that?
Not a chance-- and probably for good reason.
If multi-core CPUs weren't accounted for,
a company could just buy a server
with a single CPU you that had 10 cores and pay only $10,000.
The idea here is basing this on computing power,
the cores have to be taken into account.
But it also wouldn't be fair to count every core
as a separate CPU, so Oracle strikes
a balance between the two.
Let's say we have our four CPU server,
but each CPU has four cores.
We would calculate the license based on a multiplier,
let's say, 1.25.
So at $10,000 times four CPUs times a multiplier of 1.25,
we come up with $50,000.
Again, these are just example numbers.
Nearly every server sold today uses multi-core processors,
so this is something we need to be aware of.
The other type of licensing model is the named user model.
In this model, we don't license based on CPU hardware,
we base it on the number of people that use the database.
So Oracle charges an amount per user,
and we multiply that times the number of people
that use the database.
So let's say that Oracle charges $150 per user,
and we have 100 users.
150 times 100 users is $15,000.
So if your user base is 100 users,
it makes sense that we go with the named user model.
However, it's important that we take all of the users
into account.
What if our user base is 1,000 users?
That totals up to over three times
what we would pay for the CPU-based model.
So it's important to know what you're using the database for
and how many people use it.
The primary edition of Oracle database
is the Enterprise Edition, or EE.
Enterprise Edition is the most common edition
used, even though it is the most expensive.
Typically, a mid-sized to large company
will purchase the Enterprise Edition
to ensure that the majority of features are provided.
A very large company may enter into negotiations
with Oracle representatives to come up
with a large contract that doesn't charge full price.
Enterprise Edition has the following characteristics.
It has no maximum as to the number of CPU processors
that are allowed.
Any server with any number of CPUs is acceptable.
It has no limit as to the amount of memory allowed.
Any memory amount is allowable.
It is available in 32-bit and 64-bit versions,
depending on your operating system.
Most importantly, it allows access
to a number of features not included in other versions,
features like Data Guard for high availability,
fine-grained auditing for security,
and cross platform database recoverability.
The full list is available on the Oracle website.
These features should be taken to account in any company that
relies on Oracle.
They're not luxuries.
The Enterprise Edition includes the largest number of features
available.
The next edition is the Standard Edition, or SE.
Standard Edition is limited to systems with four or fewer CPU
sockets.
Like the Enterprise Edition, it has no limits
on memory or database size.
It includes many options, but not as many as Enterprise.
For example, both EE and SE provide a performance feature
known as Automatic Workload Management.
It is interesting to note that according to Oracle's website
Standard Edition includes full use of Oracle RAC, which
is an optional pay extra feature in the Enterprise Edition.
Standard Edition is chosen by many small to mid-sized
companies as the economical option.
Standard Edition 1, or SE, is similar to Standard Edition.
It is limited to systems with two or fewer CPU sockets.
Like the other editions, it has no limits on memory or database
size.
However, it is only available for Linux, Unix, and Windows.
It has even fewer features than the Standard Edition.
However, it costs less than SE.
It is important to note that even though the SE1 has
fewer features, all the basic functionality is present.
SE1 is an edition that small to mid-sized companies
should consider.
The final edition we'll look at is the Express Edition , or XE.
Express Edition is limited to one
CPU, one gigabyte of RAM, and a total database size of 11 gig.
Despite these limits, Oracle XE has the distinction
of being completely free.
However, one word of caution to those who are learning Oracle.
Oracle XE is really a different product
than the other editions.
It lacks so many features that it
isn't very useful in learning Oracle database.
It is primarily used in development and prototyping
situations where there is just a need for a database
to run applications against.
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.