Automatic Performance Diagnosis and Tuning in Oracle
Summary: Introduces 'Database Time' as a unified performance currency to attribute throughput impact across resources and activities. Describes ADDM, an automatic diagnostic engine using periodic historical measurements to pinpoint bottlenecks, produce actionable tuning recommendations, and enable self-managing Oracle 10g. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Karl Dias (Oracle)
- 2. Mark Ramacher (Oracle)
- 3. Uri Shaft (Oracle)
- 4. Venkateshwaran Venkataramani (Oracle)
- 5. Graham Wood (Oracle)
BibTeX Citation
@inproceedings{dias_cidr05,
address = {Amsterdam, Netherlands},
series = {{CIDR} '05},
title = {{Automatic Performance Diagnosis and Tuning in Oracle}},
booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
author = {Dias, Karl and Ramacher, Mark and Shaft, Uri and Venkataramani, Venkateshwaran and Wood, Graham},
year = {2005}
}Incoming Citations (Sorted by Pagerank)
Showing 29 of 29 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 604 | Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System | 2000 | VLDB | 0.0001566686 |
| 780 | Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering | 2002 | VLDB | 0.00014025444 |
| 1,659 | SQL Memory Management in Oracle9i | 2002 | VLDB | 9.9624689e-05 |
| 2,425 | Towards Automated Performance Tuning For Complex Workloads | 1994 | VLDB | 8.4854028e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,425 | Towards Automated Performance Tuning For Complex Workloads | 1994 | VLDB |
| 2 | 10,928 | Real-time SQL Plan Management in Oracle | 2026 | VLDB |
| 3 | 9,350 | Automatic SQL Error Mitigation in Oracle | 2023 | VLDB |
| 4 | 4,234 | Adaptive Statistics in Oracle 12c | 2017 | VLDB |
| 5 | 1,289 | An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems | 2021 | VLDB |
| 6 | 7,891 | Oracle Workload Intelligence | 2015 | SIGMOD |
| 7 | 4,708 | Parallel SQL Execution in Oracle 10g | 2004 | SIGMOD |
| 8 | 8,771 | Automatic Indexing in Oracle | 2025 | VLDB |
| 9 | 6,251 | Foundations of Automated Database Tuning | 2006 | VLDB |
| 10 | 529 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB |