Oracle real application testing

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.

REFERENCES

• 1: M. Colgan. SQL Plan Management in Oracle Database 11g. Technical report, Oracle, http://www.oracle.com, 2007.
• 2: B. Dageville and K. Dias. Oracle's Self-Tuning Architecture and Solutions. IEEE Data Engineer Bulletin. March 2006 Vol. 29.
• 3: Benoit Dageville , Dinesh Das , Karl Dias , Khaled Yagoub , Mohamed Zait , Mohamed Ziauddin, Automatic SQL tuning in oracle 10g, Proceedings of the Thirtieth international conference on Very large data bases, p.1098-1109, August 31-September 03, 2004, Toronto, Canada
• 4: K. Dias, M. Ramacher, U. Shaft, V. Venkataramani, G. Wood. Automatic Performance Diagnosis and Tuning in Oracle. CIDR 2005
• 5: Leonidas Galanis , Supiti Buranawatanachoke , Romain Colle , Benoît Dageville , Karl Dias , Jonathan Klein , Stratos Papadomanolakis , Leng Leng Tan , Venkateshwaran Venkataramani , Yujun Wang , Graham Wood, Oracle database replay, Proceedings of the 2008 ACM SIGMOD international conference on Management of data, June 09-12, 2008, Vancouver, Canada [doi>10.1145/1376616.1376732]
• 6: Oracle 11g Documentation. http://www.oracle.com/pls/db111/db111.homepage.
• 7: TPC-C, http://www.tpc.org.
• 8: K. Yagoub, P. Belknap, B. Dageville, K. Dias, S. Joshi, and H. Yu. Oracle's SQL Performance Analyzer. IEEE Data Engineering Bulletin. March 2008 Vol. 31 N

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.7 Database Administration

Additional Classification:
  C. Computer Systems Organization
  C.4 PERFORMANCE OF SYSTEMS
      Subjects: Reliability, availability, and serviceability

  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems

          Nouns: ORACLE

General Terms:
Design, Reliability