A Guide to Oracle Real Application Testing Licensing

Introduction to Oracle Real Application Testing

In database management, Oracle Real Application Testing is a cornerstone solution. This software suite offers robust testing capabilities that can significantly enhance the efficiency and performance of your Oracle databases.

This article presents a deep dive into Oracle Real Application Testing, discussing its primary features, the licensing metrics available, and the associated costs, all aimed at helping you derive the maximum value from your Oracle investment.

Key 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 is an extra cost option for Oracle Database Enterprise Edition (EE) and Oracle Database Enterprise Edition – Exadata (EE-Exa). Furthermore, it is included with Oracle Database Personal Edition (PE), Oracle Database Cloud Service Enterprise Edition (DBCS EE), Oracle Database Cloud Service Enterprise Edition – High Performance (DBCS EE-HP), Oracle Database Cloud Service Enterprise Edition – Extreme Performance (DBCS EE-EP), and Exadata Cloud Service/Cloud at Customer (ExaCS/CC).

Note that the Oracle Real Application Testing license is required on both capture and replay systems for Database Replay, with charges based on the total number of CPUs on these systems. Certain functions like Capture and Replay ASH Analytics Reports, Compare Period ADDM Reports, and Replay Compare Period Reports necessitating an Oracle Diagnostics Pack license.

Oracle Real Application Testing License Costs

As per the Oracle technology price list, the licensing cost for Oracle Real Application Testing is as follows:

• The Named User Plus license costs $230 per Named User Plus.
• The Processor License costs $11,500 per Processor.

Remember, these prices may be subject to change, and it’s recommended to consult with Oracle or an authorized Oracle reseller for the most up-to-date pricing information.

FAQs

By understanding Oracle Real Application Testing, its features, and licensing options, businesses can effectively plan and manage their Oracle investment, enhancing their database performance and driving operational efficiency.