Oracle real application testing.

ABSTRACTThis paper presents the Oracle solution for database testing delivered in the Oracle 11g Database Real Application Testing option. The first feature, the SQL Performance Analyzer, performs unit testing of the SQL of a production workload. The second feature, Database Replay, makes it possible to subject a test system to a real production system workload. Both features base their effectiveness on the fact that the best possible workload for testing is the actual production workload, which is unparalleled to our knowledge. By running the real application workload on a test system, these features can predict the impact of changes to a production system accurately and without risk. Combined with Oracle's performance manageability offerings, such as the Automatic Database Diagnostic Monitor (ADDM) and SQL Tuning Advisor, these features provide a compelling end-to-end approach for introducing change into production environments without risk of performance regression.