Automatic performance diagnosis and tuning in Oracle

2nd Biennial Conference on Innovative Data Systems Research, CIDR 2005

Volumn , Issue , 2005, Pages 84-94

  Dias, Karl ^a   Ramacher, Mark ^a   Shaft, Uri ^a   Venkataramani, Venkateshwaran ^a   Wood, Graham ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DIAGNOSTIC INFORMATION; HOLISTIC VIEW; ORACLE 10G; PERFORMANCE DIAGNOSIS; PERFORMANCE IMPACT; PERFORMANCE ISSUES; PERFORMANCE MEASUREMENTS; PERFORMANCE TUNING;

DATABASE SYSTEMS;

EID: 84858830809     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (23)

1. D. G. Benoit. Automatic Diagnosis of Performance Problems in Database Management Systems, PhD Thesis, Queen's University, Canada, 2003.
2. K. P. Brown, M. Mehta, M.J. Carey, M. Livny: Towards Automated Performance Tuning for Complex Workloads. 20th International Conference on Very Large Data Bases, Santiago, Chile, 1994.
3. S. Chaudhuri, V. Narasayya: An Efficient, Cost-driven Index Tuning Wizard for Microsoft SQL Server, 23rd International Conference on Very Large Data Bases, Athens, Greece, 1997.
4. S. Chaudhuri and G. Weikum: Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System. 26th International Conference on Very Large Data Bases, Cairo, Egypt, 2000.
5. B. Dageville, M. Zait: SQL Memory Management in Oracle9i, 28th International Conference on Very Large Data Bases, Hong Kong, China, 2002.
6. S. Elnaffar, W. Powley, D. Benoit, P. Martin: Today's DBMSs: How Autonomic Are They? Proceedings of the First IEEE International Autonomic Systems Workshop, Prague, DEXA 2003.
7. Gartner Group: Total Cost of Ownership: The Impact of System Management Tools, 1996.
8. J. L. Hellerstein. Automated Tuning Systems: Beyond Decision Support. In the proceedings on Computer Measurement Group, 1997
9. Hurwitz Group: Achieving Faster Time-to-Benefit and Reduced TCO with Oracle Certified Configurations, March 2002.
10. IBM Corporation: DB2 Universal Database Version 8 Guide to GUI Tools for Administration and Development, IBM Corporation, 2003.
11. IBM Corporation: DB2 Universal Database Version 8 Administration Guide: Performance, IBM Corporation, 2003.
12. Microsoft Corporation: RDBMS Performance Tuning Guide for Data Warehousing, Chapter 20, SQL Server 2000 Resource Kit.
13. Oracle Corporation: Oracle 9i Database Manageability, Oracle White Paper, http://www.oracle.com/technology/products/manageability/database/pdf/ Oracle9iManageabilityBWP.pdf
14. Oracle Corporation: Oracle Database 10g: The Self-Managing Database, Oracle White Paper, http://www.oracle.com/technology/products/manageability/ database/pdf/twp03/TWP-manage-self-managing-database.pdf
15. Oracle Corporation: Oracle 8i Designing and Tuning for Performance Release 2, Oracle 8i Documentation, http://tahiti.oracle.com
16. Oracle Corporation: Oracle 9i Database Performance Tuning Guide and Reference, Oracle 9i Documentation, http://tahiti.oracle.com
17. Oracle Corporation: Query Optimization in Oracle 9i, Oracle White Paper, http://www.oracle.com/technology/products/bi/pdf/o9i-optimization-twp.pdf
18. Oracle Corporation: The Self-Managing Database: Guided Application and SQL Tuning, Oracle White Paper, http://www.oracle.com/technology/products/ manageability/database/pdf/twp03/TWP-manage-automatic-SQL-tuning.pdf
19. Oracle Corporation: The Self-Managing Database: Proactive Space and Schema Object Management, Oracle Presentation, http://www.oracle.com/technology/ products/manageability/database/pdf/ow03p/40170p.pdf
20. Oracle Corporation: Diagnosing Performance Bottlenecks using Statspack and The Oracle Performance Method, Oracle White Paper, http://www.oracle.com/ technology/deploy/performance/pdf/statspack-opm4.pdf
21. Oracle Corporation: Diagnosing Performance Using Statspack, Oracle White Paper, http://www.oracle.com/technology/deploy/performance/pdf/statspack.pdf
22. G. Weikum, C. Hasse, A. Mönkeberg, P. Zabback: The COMFORT Automatic Tuning Project, Information Systems, Vol. 19, No. 5, pp. 381-432, 1994. (Pubitemid 124012586)
23. G. Weikum, A. Mönkeberg, C. Hasse, P. Zabback: Selftuning Database Technology and Information Services: From Wishful Thinking to Viable Engineering, 28th International Conference on Very Large Data Bases, Hong Kong, China, 2002.