1 Introduction to Oracle Database Testing
The Oracle Real Application Testing option of Oracle Database help you to securely assure the integrity of database changes and to manage test data.
Oracle Real Application Testing option enables you to perform real-world testing of Oracle Database. By capturing production workloads and assessing the impact of system changes on these workloads before production deployment, Oracle Real Application Testing minimizes the risk of instabilities associated with system changes. SQL Performance Analyzer and Database Replay are key components of Oracle Real Application Testing. Depending on the nature and impact of the system change being tested, and on the type of system the test will be performed, you can use either or both components to perform your testing.
This chapter contains the following sections:
Note:
The use of SQL Performance Analyzer and Database Replay requires the Oracle Real Application Testing licensing option. For more information, see Oracle Database Licensing Information User Manual.
1.1 SQL Performance Analyzer
SQL Performance Analyzer automates the process of assessing the overall effect of a change on the full SQL workload by identifying performance divergence for each SQL statement. A report that shows the net impact on the workload performance due to the change is provided. For regressed SQL statements, SQL Performance Analyzer also provides appropriate execution plan details along with tuning recommendations. As a result, you can remedy any negative outcome before the end users are affected. Furthermore, you can validate—with significant time and cost savings—that the system change to the production environment will result in net improvement.
You can use the SQL Performance Analyzer to analyze the impact on SQL performance of any type of system changes, including:
-
Database upgrade
-
Database consolidation testing for pluggable databases (PDBs) and manual schema consolidation
-
Configuration changes to the operating system or hardware
-
Schema changes
-
Changes to database initialization parameters
-
Refreshing optimizer statistics
-
Validating SQL tuning actions
See Also:
-
Introduction to SQL Performance Analyzer for information about using SQL Performance Analyzer
1.2 Database Replay
Database Replay enables realistic testing of system changes by essentially re-creating the production workload environment on a test system. Using Database Replay, you can capture a workload on the production system and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This enables you to fully assess the impact of the change, including undesired results, new contention points, or plan regressions. Extensive analysis and reporting is provided to help identify any potential problems, such as new errors encountered and performance divergence.
Database Replay captures the workload of external database clients at the database level and has negligible performance overhead. Capturing the production workload eliminates the need to develop simulation workloads or scripts, resulting in significant cost reduction and time savings. By using Database Replay, realistic testing of complex applications that previously took months using load simulation tools can now be completed in days. This enables you to rapidly test changes and adopt new technologies with a higher degree of confidence and at lower risk.
You can use Database Replay to test any significant system changes, including:
-
Database and operating system upgrades
-
Database consolidation testing for PDBs and manual schema consolidation
-
Authoring and experimenting with various scenarios using workload scale-up
-
Configuration changes, such as conversion of a database from a single instance to an Oracle Real Application Clusters (Oracle RAC) environment
-
Storage, network, and interconnect changes
-
Operating system and hardware migrations
See Also:
-
Introduction to Database Replay for information about using Database Replay