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.
Main Features of Oracle OLAP
Oracle OLAP comes packed with a variety of features designed to enhance and simplify your analytical processes:
- OLAP Cube Definition, Storage, and Querying: This feature allows you to define, store, and query multidimensional OLAP cubes for efficient and complex data analysis.
- OLAP API and Metadata: You can manage metadata and interact with OLAP data using a programmable interface, which allows for customizable data interactions.
- OLAP Cube Materialized Views: These views enable the precomputation and storage of OLAP cube data, increasing query performance.
- Analytic Workspaces: This provides a flexible and efficient environment for developing advanced analytical applications and storing multidimensional data.
- SQL Access to OLAP Cubes: OLAP data can be accessed using SQL, allowing seamless integration with Oracle database tools and any SQL-compatible applications.
Oracle OLAP Licensing
Oracle OLAP Licensing and Cost Examples
Additional Cost Option
Oracle OLAP is an extra-cost option for Oracle Database Enterprise Edition (EE) and Oracle Database Enterprise Edition – Exadata (EE-Exa).
It 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).
Licensing Model
The licensing for Oracle OLAP must align with the same metric and quantity as your Oracle Database Enterprise Edition license.
If you have a processor-based license for Oracle Database EE, you must license Oracle OLAP using the processor-based model. Similarly, if you use a Named User Plus (NUP) model for Oracle Database EE, you must follow the same for Oracle OLAP.
Example Calculation
Processor-Based License:
- If you have six processors for Oracle Database EE, you need six processor licenses for Oracle OLAP.
- Cost: 6 processors x $23,000 per processor = $138,000.
Named User Plus (NUP) License:
- If you have 100 named users for Oracle Database EE, you need 100 NUP licenses for Oracle OLAP.
- Cost: 100 users x $460 per NUP = $46,000.
FAQ on Oracle OLAP Licensing and Costs
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 you must ensure the new licensing model aligns with your Oracle Database Enterprise Edition license.
