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.0001566968
Overall Rank: 625 | 95.72%
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 28 of 28 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
86	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00035316107
234	Self-Driving Database Management Systems	2017	CIDR	0.00023810722
334	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.00020875082
523	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00017133451
798	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00013919795
861	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00013543212
887	E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems	2015	VLDB	0.00013403455
1,344	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00011094717
1,686	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	0.00010008686
1,920	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.4846185e-05
3,063	Oracle Database Replay	2008	SIGMOD	7.802088e-05
3,586	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	7.2834069e-05
3,587	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	7.2829345e-05
3,662	openGauss: An Autonomous Database System	2021	VLDB	7.2166682e-05
4,011	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	6.959982e-05
4,958	Why Did My Query Slow Down?	2009	CIDR	6.428827e-05
5,023	DBPA: A Benchmark for Transactional Database Performance Anomalies	2023	SIGMOD	6.3979497e-05
5,856	Automatic Database Configuration Debugging using Retrieval-Augmented Language Models	2025	SIGMOD	6.0644656e-05
5,865	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	6.0619534e-05
5,974	Towards instance-optimized data systems	2021	VLDB	6.0230488e-05
6,082	iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks	2019	SIGMOD	5.9841079e-05
7,098	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	5.7046615e-05
7,261	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	5.6612613e-05
8,710	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	5.378796e-05
8,723	Your Read is Our Priority in Flash Storage	2022	VLDB	5.3769695e-05
10,532	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	5.093636e-05
11,049	DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs	2025	VLDB	5.093636e-05
11,150	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	5.093636e-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
600	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.00015871387
781	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00014085674
1,706	SQL Memory Management in Oracle9i	2002	VLDB	9.9628446e-05
2,403	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	8.6233649e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,664	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB
2	2,403	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB
3	9,240	Automatic SQL Error Mitigation in Oracle	2023	VLDB
4	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB
5	7,740	Oracle Workload Intelligence	2015	SIGMOD
6	1,344	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB
7	4,633	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
8	11,003	Automatic Indexing in Oracle	2025	VLDB
9	6,131	Foundations of Automated Database Tuning	2006	VLDB
10	524	Automatic SQL Tuning in Oracle 10g	2004	VLDB