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)

Paper ID: 30
Venue: CIDR
Year: 2005
Pagerank: 0.00017003914
Overall Rank: 760 | 94.72%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 28 of 28 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
183	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00036859633
371	Self-Driving Database Management Systems	2017	CIDR	0.00025382677
510	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.00021420477
661	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00018488168
886	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00015563003
1,024	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00014601525
1,091	E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems	2015	VLDB	0.00014133147
1,816	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00010438512
1,892	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	0.00010176219
1,953	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.9701097e-05
3,102	Oracle Database Replay	2008	SIGMOD	7.5604346e-05
4,151	openGauss: An Autonomous Database System	2021	VLDB	6.4020605e-05
4,216	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	6.3448176e-05
4,377	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	6.2331947e-05
4,799	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	5.9082876e-05
4,870	DBPA: A Benchmark for Transactional Database Performance Anomalies	2023	SIGMOD	5.8583776e-05
4,938	Why Did My Query Slow Down?	2009	CIDR	5.8140945e-05
6,125	iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks	2019	SIGMOD	5.1949154e-05
6,265	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	5.1294788e-05
6,298	Towards instance-optimized data systems	2021	VLDB	5.1182917e-05
6,564	Automatic Database Configuration Debugging using Retrieval-Augmented Language Models	2025	SIGMOD	5.0037892e-05
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8589148e-05
7,325	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	4.7564908e-05
8,797	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	4.4444672e-05
8,806	Your Read is Our Priority in Flash Storage	2022	VLDB	4.44219e-05
10,244	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	4.1905499e-05
10,827	DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs	2025	VLDB	4.1905499e-05
10,934	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.1905499e-05

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
528	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.0002085799
841	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00015987128
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.00010471365
2,069	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6356256e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,016	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB	7.7060968e-05
2,069	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6356256e-05
9,141	Automatic SQL Error Mitigation in Oracle	2023	VLDB	4.382234e-05
4,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05
7,602	Oracle Workload Intelligence	2015	SIGMOD	4.6964845e-05
1,816	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00010438512
4,260	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.3033486e-05
10,780	Automatic Indexing in Oracle	2025	VLDB	4.1905499e-05
6,494	Foundations of Automated Database Tuning	2006	VLDB	5.0334983e-05
495	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00021712703