We must have been involved in only technical activities and issues on Oracle database every day, but most of the DBA’s must have a limited or no knowledge on how Oracle charges customers with their license models. Most of us might know that Oracle database is free for learning, testing and for any non-profit applications or firms. When I have asked few of my colleagues about the commercial license, they just say that Oracle database licensing is based on a number of cores in your processor. Hope you might be one of them too
.
To the professionals who do not know, there are two models from Oracle in purchasing database licenses for commercial purposes. Let us check the licensing terms and their prices for the most widely used features in database enterprise edition.
These license details are gathered from Oracle as on 21-Jan-2016 and might change any time.
Type of licenses:
Oracle has two types of database licenses and one for software update and meta-link that you can choose from.
1. User based (Named User Plus).
Licensed based on a number of users accessing the database whether programmatically or end user. This sort of licensing is very much suitable for a fixed intranet application where users are fixed and no major scalability. But Oracle sells a minimum of 25 users for Enterprise Edition per CPU.
Cons: Even though your application have only 10 users, you will need to pay for 25.
2. Processor based.
From the name, though we understand it per processor with respect to Oracle this is different to multi-core processors. Today, every server is running on multi-core processors. Oracle calculates the number of processors on the server as “(number of cores) * (multi-core factor)”.
Each make of processor has their respective multi-core factor. Few examples:
• 0.5 for Intel/AMD.
• 0.25 for UltraSPARC.
• 1.00 for IBM Power systems.
• 0.25 for UltraSPARC.
• 1.00 for IBM Power systems.
Cost for Enterprise edition:
1. For User-based:
Price per user: 950 $
Software update and support price: 209 $
2. For Processor based:
Processor license: 47,500 $
Software update and support price: 10,450 $
Price per user: 950 $
Software update and support price: 209 $
2. For Processor based:
Processor license: 47,500 $
Software update and support price: 10,450 $
It will be interesting to know how much would few of EE options like RAC, Partitioning etc… would cost. Isn’t it? Let us see that.
Option
|
Per user license
|
Support license
|
Processor license
|
Support license
|
Diagnostic pack
|
150 $
|
33 $
|
7500 $
|
1650 $
|
Tuning pack
|
100 $
|
22 $
|
5000 $
|
1100 $
|
12c Multitenancy
|
350 $
|
77 $
|
17500 $
|
3850 $
|
Partitioning
|
230 $
|
50 $
|
11500 $
|
2530 $
|
Compression
|
230 $
|
50 $
|
11500 $
|
2530 $
|
RAC
|
460 $
|
101 $
|
23,000 $
|
5060 $
|
Active dataguard
|
230 $
|
50 $
|
11500 $
|
2530 $
|
These prices are additional on top of enterprise license that is purchased.
Case study:
Hope the numbers that are projected are scattered to get a clear picture of total costs incurred in the database. Let us take a scenario and calculate the licensing costs.
Requirement – Calculate license for Oracle database EE with Diagnostic pack, Partitioning and tuning pack including support on Intel quad-core processor for unlimited users.
Calculation –
• It falls under processor based licensing as the requirement is for unlimited users.
• Number of processors (P) = (Quad Core)*(multi-core factor) = 4*0.5 = 2.
• EE Oracle database cost (DB) = 47500 $.
• EE options cost (OP) = Diagnostic + Tuning + Partitioning = 7500 $ + 5000 $ + 11500 $ = 24000 $.
• Support license cost (SP) = EE + Diagnostic pack + Tuning + Partitioning = 10450 $ + 1650 $ + 1100 $ + 2530 $ = 15730 $
• Number of processors (P) = (Quad Core)*(multi-core factor) = 4*0.5 = 2.
• EE Oracle database cost (DB) = 47500 $.
• EE options cost (OP) = Diagnostic + Tuning + Partitioning = 7500 $ + 5000 $ + 11500 $ = 24000 $.
• Support license cost (SP) = EE + Diagnostic pack + Tuning + Partitioning = 10450 $ + 1650 $ + 1100 $ + 2530 $ = 15730 $
Total cost is now calculated as = Number of processors*(EE Oracle database cost + EE options cost) + Support license cost = P*(DB+OP) + SP = 2*(47500+24000) $ + 15730 $ = 158730 $
It’s 158730 $, that’s very huge isn’t it?
You must be now thinking what will be the validity of this license , right? That’s another tricky one from Oracle, they have licenses without any term validities and also with 5 or 4 or 3 or 2 or 1 years of term validity. It’s only my perception that the total price we calculated in our case study is valid until you seek for termination.
, right? That’s another tricky one from Oracle, they have licenses without any term validities and also with 5 or 4 or 3 or 2 or 1 years of term validity. It’s only my perception that the total price we calculated in our case study is valid until you seek for termination.
For further details on licensing please refer – http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf
Bullet-ins:
• Not just production systems, Oracle licenses are applicable to your non-production systems as well.
• Oracle may track your “Named User Plus” licenses based on results from the v$license.
• Oracle may track your “Processor” licenses from any of your AWR reports that you upload to meta-link
.
• Oracle may track your “Named User Plus” licenses based on results from the v$license.
• Oracle may track your “Processor” licenses from any of your AWR reports that you upload to meta-link
.
Comments
Post a Comment