Oracle OLAP Licensing
- Extra Cost Option: For Oracle Database Enterprise Edition (EE) and EE-Exadata.
- In: Oracle Database PE, DBCS EE-HP, DBCS EE-EP, ExaCS/CC.
- License Match: Must match Oracle Database EE’s metric and quantity.
- Costs:
- Named User Plus: $460 per user
- Processor: $23,000 per processor.
Oracle OLAP Licensing
Oracle OLAP (Online Analytical Processing) is a robust add-on for Oracle Database Enterprise Edition (EE) and Oracle Database Enterprise Edition – Exadata (EE-Exa).
It is designed to optimize analytical processing and enable advanced business intelligence capabilities.
Organizations leveraging this tool must understand its licensing model.
Licensing Overview
Additional Cost Option
Oracle OLAP is not included by default with Oracle Database Enterprise Edition. It is offered as an additional cost option.
However, it is included at no extra cost in:
- Oracle Database Personal Edition (PE)
- Oracle Database Cloud Service Enterprise Edition – High Performance (DBCS EE-HP)
- Oracle Database Cloud Service Enterprise Edition – Extreme Performance (DBCS EE-EP)
- Oracle Exadata Cloud Service (ExaCS/CC)
Stand-Alone Licensing Option
Oracle OLAP is also a stand-alone license for Oracle Database Enterprise Edition. This offers flexibility for organizations requiring OLAP functionalities without other advanced database features.
Licensing Models
Licenses for Oracle OLAP must align with the Oracle Database Enterprise Edition’s licensing model. Two primary licensing metrics are available:
- Processor-Based Licensing:
- Suitable for large-scale deployments where user counts are challenging to define.
- Based on the number of processors used in the database environment.
- Named User Plus (NUP) Licensing:
- Ideal for smaller deployments with a defined user base.
- Licenses are tied to the number of users accessing the database.
Oracle OLAP Licensing Costs
Processor-Based Licensing
- Cost per Processor: $23,000 (as per Oracle’s price list).
- Calculation Example:
- Scenario: A database environment with eight processors.
- Calculation: 8 processors × $23,000 per processor.
- Total Cost: $184,000.
Named User Plus (NUP) Licensing
- Cost per NUP: $460 (as per Oracle’s price list).
- Calculation Example:
- Scenario: 200 named users accessing Oracle OLAP.
- Calculation: 200 users × $460 per NUP.
- Total Cost: $92,000.
Licensing Guidelines
- Align with Database Licensing:
- Oracle OLAP licensing must match the Oracle Database EE’s licensing model and quantity.
- For processor-based licensing, the number of processor licenses for OLAP must equal those for the database.
- Clustered Environments:
- All nodes in a cluster must be licensed for Oracle OLAP.
- Audit Readiness:
- Maintain accurate records of licenses and ensure compliance with Oracle’s policies to avoid penalties.
- License Transferability:
- Licenses can be reassigned to different servers, provided reassignment complies with Oracle’s policies.
FAQs
What is Oracle OLAP?
Oracle OLAP (Online Analytical Processing) is an extra cost option for Oracle Database Enterprise Edition (EE) and Oracle Database Enterprise Edition – Exadata (EE-Exa). It provides advanced analytical capabilities.
Which editions include Oracle OLAP without additional cost?
Oracle OLAP is included with Oracle Database Personal Edition (PE), Oracle Database Cloud Service Enterprise Edition – High Performance (DBCS EE-HP), Oracle Database Cloud Service Enterprise Edition – Extreme Performance (DBCS EE-EP), and Oracle Exadata Cloud Service (ExaCS/CC).
How is Oracle OLAP licensed?
The licensing for Oracle OLAP must match the metric and quantity of your Oracle Database Enterprise Edition license, either by Processor or Named User Plus (NUP).
What is the cost of a Named User Plus license for Oracle OLAP?
The Named User Plus license costs $460 per Named User Plus.
What is the cost of a Processor license for Oracle OLAP?
A Processor License costs $23,000 per Processor.
How do I calculate the number of licenses needed for Oracle OLAP?
You need to match the metric and quantity of your existing Oracle Database Enterprise Edition licenses. For example, if you have four processor licenses for Oracle Database EE, you need four licenses for Oracle OLAP.
Can Oracle OLAP be used with Oracle Database Personal Edition?
Oracle OLAP is included with Oracle Database Personal Edition (PE) without additional cost.
Is Oracle OLAP available in Oracle’s cloud services?
Yes, Oracle OLAP is included with Oracle Database Cloud Service Enterprise Edition – High Performance (DBCS EE-HP), Oracle Database Cloud Service Enterprise Edition – Extreme Performance (DBCS EE-EP), and Oracle Exadata Cloud Service (ExaCS/CC).
Does Oracle OLAP require separate licenses for different environments?
Yes, Oracle OLAP licensing must align with the specific environments it is deployed in, matching the Oracle Database EE licensing.
Are there any special considerations for Oracle OLAP on Exadata?
Oracle OLAP is an extra cost option for Oracle Database Enterprise Edition – Exadata (EE-Exa), but it is included with Oracle Exadata Cloud Service (ExaCS/CC).
Is there a difference in cost between using Oracle OLAP on-premises and in the cloud?
The cost structure can vary, and it’s best to check with Oracle for specific pricing details related to on-premises and cloud deployments.
What factors influence the cost of Oracle OLAP licenses?
The primary factors include the number of processors or named users, the Oracle Database edition, and the deployment environment (on-premises or cloud).
Can I switch from a Named User Plus license to a Processor license for Oracle OLAP?
You can switch but must ensure the new licensing model aligns with your Oracle Database Enterprise Edition license.
