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: h63ce4be8fa0e5197
Venue: CIDR
Year: 2005
Pagerank: 0.00015964021
Overall Rank: 583 | 96.10%
DOI: -

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 30 of 30 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
74	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00037164008
224	Self-Driving Database Management Systems	2017	CIDR	0.00023973185
309	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.0002143249
496	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00017347275
757	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00014202187
830	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00013571967
891	E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems	2015	VLDB	0.00013211469
1,294	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00011129451
1,656	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.948529e-05
1,700	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	9.8224761e-05
3,113	Oracle Database Replay	2008	SIGMOD	7.6200856e-05
3,486	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	7.2428834e-05
3,575	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	7.1769215e-05
3,687	openGauss: An Autonomous Database System	2021	VLDB	7.0797286e-05
3,839	Automatic Database Configuration Debugging using Retrieval-Augmented Language Models	2025	SIGMOD	6.9704205e-05
4,101	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	6.7930727e-05
5,037	Why Did My Query Slow Down?	2009	CIDR	6.2907346e-05
5,098	DBPA: A Benchmark for Transactional Database Performance Anomalies	2023	SIGMOD	6.2631174e-05
5,979	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	5.910201e-05
5,982	Towards instance-optimized data systems	2021	VLDB	5.9096991e-05
6,126	iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks	2019	SIGMOD	5.8614712e-05
7,249	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.5586903e-05
7,393	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	5.5202899e-05
8,876	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	5.2452058e-05
8,912	Your Read is Our Priority in Flash Storage	2022	VLDB	5.236464e-05
10,377	AGRL: An Agentic GraphRAG Framework with Reinforcement Learning for Database Configuration Debugging	2027	SIGMOD	4.9605343e-05
10,787	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	4.9605343e-05
10,978	DBAgent: An RL-Based Agent for Autonomous Database Operations and Maintenance	2026	VLDB	4.9605343e-05
11,471	DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs	2025	VLDB	4.9605343e-05
11,556	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.9605343e-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
604	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.00015642703
775	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00014062388
1,652	SQL Memory Management in Oracle9i	2002	VLDB	9.9624199e-05
2,420	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	8.4802011e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,420	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB
2	9,385	Automatic SQL Error Mitigation in Oracle	2023	VLDB
3	10,998	Real-time SQL Plan Management in Oracle	2026	VLDB
4	4,252	Adaptive Statistics in Oracle 12c	2017	VLDB
5	7,910	Oracle Workload Intelligence	2015	SIGMOD
6	1,294	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB
7	4,721	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
8	8,798	Automatic Indexing in Oracle	2025	VLDB
9	6,265	Foundations of Automated Database Tuning	2006	VLDB
10	532	Automatic SQL Tuning in Oracle 10g	2004	VLDB