Oracle real application testing

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

Oracle real application testing

Full text

Pdf (201 KB)

Source

International Conference on Management of Data archive
Proceedings of the 1st international workshop on Testing database systems table of contents

Vancouver, British Columbia, Canada

SESSION: War stories table of contents

Article No. 1

Year of Publication: 2008

ISBN:978-1-60558-233-7

Authors

Peter Belknap	Oracle USA, Redwood City, CA
Supiti Buranawatanachoke	Oracle USA, Redwood City, CA
Romain Colle	Oracle USA, Redwood City, CA
Benoît Dageville	Oracle USA, Redwood City, CA
Karl Dias	Oracle USA, Redwood City, CA
Leonidas Galanis	Oracle USA, Redwood City, CA
Shantanu Joshi	Oracle USA, Redwood City, CA
Jonathan Klein	Oracle USA, Redwood City, CA
Stratos Papadomanolakis	Oracle USA, Redwood City, CA
Uri Shaft	Oracle USA, Redwood City, CA
Leng Tan	Oracle USA, Redwood City, CA
Venkateshwaran Venkataramani	Oracle USA, Redwood City, CA
Yujun Wang	Oracle USA, Redwood City, CA
Graham Wood	Oracle USA, Redwood City, CA
Khaled Yagoub	Oracle USA, Redwood City, CA
Hailing Yu	Oracle USA, Redwood City, CA

Sponsor

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 37, Downloads (12 Months): 75, Citation Count: 0

Additional Information:

abstract references collaborative colleagues

Tools and Actions:	Review this Article Save this Article to a Binder Display Formats: BibTex EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/1385269.1385271 What is a DOI?

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

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked 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	B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zait, and M. Ziauddin. Automatic SQL Tuning in Oracle 10g. In VLDB, pages 1098--1109, 2004.
	4	K. Dias, M. Ramacher, U. Shaft, V. Venkataramani, G. Wood. Automatic Performance Diagnosis and Tuning in Oracle. CIDR 2005
	5	L. Galanis, S. Buranawatanachoke, R. Colle, B. Dageville, K. Dias, J. Klein, S. Papadomanolakis, L. L. Tan, V. Venkataramani, Y. Wang, G. Wood. Oracle Database Replay. SIGMOD 2008
	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