Oracle real application testing

Authors:
Peter Belknap;Supiti Buranawatanachoke;Romain Colle;Benoît Dageville;Karl Dias;Leonidas Galanis;Shantanu Joshi;Jonathan Klein;Stratos Papadomanolakis;Uri Shaft;Leng Tan;Venkateshwaran Venkataramani;Yujun Wang;Graham Wood;Khaled Yagoub;Hailing Yu
Affiliations:
Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA
Venue:
Proceedings of the 1st international workshop on Testing database systems
Year:
2008

Citing 2
Cited 1

Automatic SQL tuning in oracle 10g

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Oracle database replay

Proceedings of the 2008 ACM SIGMOD international conference on Management of data

Towards workflow-driven database system workload modeling

Proceedings of the Second International Workshop on Testing Database Systems

Quantified Score

Hi-index	0.01

Visualization

Abstract

This 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.