database licensing

A Guide to Oracle Real Application Testing Licensing

database licensing

A Guide to Oracle Real Application Testing Licensing

Real Application Testing Licensing

  • Extra Cost Option: For Oracle Database Enterprise Edition (EE) and EE-Exadata.
  • In: Oracle Database PE, DBCS EE, DBCS EE-HP, DBCS EE-EP, ExaCS/CC.
  • License Match: Must align with Oracle Database EE’s metric and quantity.
  • Costs:
    • Named User Plus: $230 per user.
    • Processor: $11,500 per processor.
  • Example Costs:
    • 14 processors (capture + replay) = 14 x $11,500 = $161,000.
    • 300 named users (capture + replay) = 300 x $230 = $69,000.

Key Features of Oracle Real Application Testing

Features of Oracle Real Application Testing

Oracle Real Application Testing has many features to facilitate comprehensive and efficient testing of your Oracle databases.

Notable features include:

  1. Database Replay: This feature enables you to capture and replay database workload on different systems, aiding in practical performance analysis and tuning.
  2. SQL Performance Analyzer (SPA): SPA empowers you to forecast the impact of system changes on SQL performance, thus helping avoid potential issues before they affect your production environment.
  3. Database Migration Planner: Formerly known as the Database Consolidation Workbench, this tool provides a systematic, data-driven approach to database consolidation, eliminating guesswork and human errors.
  4. Database Migration Workbench: This feature integrates all the requirements for migration sizing and performance comparison in a single workbench, significantly simplifying the migration process.

Oracle Real Application Testing Licensing

Oracle Real Application Testing Licensing

Oracle Real Application Testing is an extra cost option for Oracle Database Enterprise Edition (EE) and Oracle Database Enterprise Edition – Exadata (EE-Exa).

It is included at no extra cost in Oracle Database Personal Edition (PE), Oracle Database Cloud Service Enterprise Edition (DBCS EE), DBCS EE-High Performance (DBCS EE-HP), DBCS EE-Extreme Performance (DBCS EE-EP), and Exadata Cloud Service/Cloud at Customer (ExaCS/CC).

Licensing Requirements

The Oracle Real Application Testing license is required on both the capture and replay systems for Database Replay.

Charges are based on the total number of CPUs on these systems. Additionally, certain functions like Capture and Replay ASH Analytics Reports, Compare Period ADDM Reports, and Replay Compare Period Reports require an Oracle Diagnostics Pack license.

License Costs

Based on the Oracle technology price list, the costs are as follows:

  • Named User Plus (NUP) License: $230 per Named User Plus.
  • Processor License: $11,500 per Processor.

Example Calculations

Processor-Based License:

  • Scenario: You have eight processors for the capture and 6 for the replay systems.
  • Calculation: Total processors = 8 (capture) + 6 (replay) = 14 processors.
  • Cost: 14 processors x $11,500 per processor = $161,000.

Named User Plus (NUP) License:

  • Scenario: You have 150 named users on both the capture and replay systems.
  • Calculation: Total named users = 150 (capture) + 150 (replay) = 300 NUP.
  • Cost: 300 NUP x $230 per NUP = $69,000.

FAQ on Oracle Real Application Testing Licensing and Costs

What is Oracle Real Application Testing?

Oracle Real Application Testing allows you to test the impact of system changes by capturing production workloads and replaying them in a test environment.

Is Oracle Real Application Testing an extra cost option?

Yes, it is an extra cost option for Oracle Database Enterprise Edition (EE) and Oracle Database Enterprise Edition – Exadata (EE-Exa).

Is Oracle Real Application Testing included with any editions for free?

Yes, it is included with Oracle Database Personal Edition (PE), Oracle Database Cloud Service Enterprise Edition (DBCS EE), DBCS EE-High Performance (DBCS EE-HP), DBCS EE-Extreme Performance (DBCS EE-EP), and Exadata Cloud Service/Cloud at Customer (ExaCS/CC).

How is Oracle Real Application Testing licensed?

The licensing must match the metric and quantity of your Oracle Database Enterprise Edition license, either by Processor or Named User Plus (NUP). Licensing is required on both capture and replay systems.

What is a Named User Plus license cost for Oracle Real Application Testing?

The Named User Plus license costs $230 per Named User Plus.

What is the cost of a Processor license for Oracle Real Application Testing?

A Processor License costs $11,500 per Processor.

How do I calculate the number of processor licenses needed?

Add the number of processors on both the capture and replay systems. For example, if you have eight processors on the capture system and six on the replay system, the total is 14 processors. Cost: 14 processors x $11,500 = $161,000.

How do I calculate the number of Named User Plus licenses needed?

Add the number of named users on both the capture and replay systems. For example, if you have 150 named users on each system, the total is 300 NUP. Cost: 300 NUP x $230 = $69,000.

Do I need additional licenses for certain features?

Features like Capture and Replay ASH Analytics Reports, Compare Period ADDM Reports, and Replay Compare Period Reports require an Oracle Diagnostics Pack license.

Is Oracle Real Application Testing available for cloud deployments?

It can be used in cloud deployments, including specific Oracle Database Cloud Service editions and Exadata Cloud Service.

Can the licensing model differ from the primary Oracle Database license?

No, the Oracle Real Application Testing licensing model must match the primary Oracle Database Enterprise Edition license.

Are there any additional costs besides licensing fees?

Consider potential additional costs for support and maintenance. Consult Oracle for detailed pricing.

What factors influence the total cost of Oracle Real Application Testing licenses?

Total costs depend on the number of processors or named users, the primary Oracle Database license type, and deployment specifics.

Can I switch from a Named User Plus license to a Processor license?

Yes, but ensure the new licensing model aligns with your Oracle Database Enterprise Edition license.

Contact us for assistance.

Please enable JavaScript in your browser to complete this form.

Author

  • Fredrik Filipsson

    Fredrik Filipsson brings two decades of Oracle license management experience, including a nine-year tenure at Oracle and 11 years in Oracle license consulting. His expertise extends across leading IT corporations like IBM, enriching his profile with a broad spectrum of software and cloud projects. Filipsson's proficiency encompasses IBM, SAP, Microsoft, and Salesforce platforms, alongside significant involvement in Microsoft Copilot and AI initiatives, improving organizational efficiency.

    View all posts