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.0001575517
Overall Rank: 598 | 95.99%
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 29 of 29 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
78	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00036675568
224	Self-Driving Database Management Systems	2017	CIDR	0.00024011047
314	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.00021276452
508	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00017083245
783	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.0001401708
836	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00013567566
891	E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems	2015	VLDB	0.00013241227
1,289	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00011159167
1,659	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.9625133e-05
1,699	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	9.8403606e-05
3,104	Oracle Database Replay	2008	SIGMOD	7.6450896e-05
3,487	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	7.2603973e-05
3,588	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	7.1841858e-05
3,680	openGauss: An Autonomous Database System	2021	VLDB	7.1016555e-05
4,080	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	6.8151596e-05
4,113	Automatic Database Configuration Debugging using Retrieval-Augmented Language Models	2025	SIGMOD	6.7964307e-05
5,035	Why Did My Query Slow Down?	2009	CIDR	6.3020913e-05
5,080	DBPA: A Benchmark for Transactional Database Performance Anomalies	2023	SIGMOD	6.2830313e-05
5,969	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	5.9296488e-05
5,973	Towards instance-optimized data systems	2021	VLDB	5.9281867e-05
6,113	iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks	2019	SIGMOD	5.880013e-05
7,233	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.5766914e-05
7,373	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	5.5384669e-05
8,855	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	5.2624701e-05
8,892	Your Read is Our Priority in Flash Storage	2022	VLDB	5.2538364e-05
10,726	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	4.9769913e-05
10,917	DBAgent: An RL-Based Agent for Autonomous Database Operations and Maintenance	2026	VLDB	4.9769913e-05
11,418	DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs	2025	VLDB	4.9769913e-05
11,504	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.9769913e-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.00015664234
781	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00014019939
1,660	SQL Memory Management in Oracle9i	2002	VLDB	9.9581502e-05
2,426	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	8.4818359e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,426	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB
2	10,937	Real-time SQL Plan Management in Oracle	2026	VLDB
3	9,359	Automatic SQL Error Mitigation in Oracle	2023	VLDB
4	4,234	Adaptive Statistics in Oracle 12c	2017	VLDB
5	7,895	Oracle Workload Intelligence	2015	SIGMOD
6	1,289	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB
7	4,710	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
8	8,779	Automatic Indexing in Oracle	2025	VLDB
9	6,254	Foundations of Automated Database Tuning	2006	VLDB
10	529	Automatic SQL Tuning in Oracle 10g	2004	VLDB