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.00017016449
Overall Rank: 765 | 94.68%
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.00036721403
359	Self-Driving Database Management Systems	2017	CIDR	0.0002592783
514	An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning	2019	SIGMOD	0.0002124895
663	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00018469455
887	Automatic Virtual Machine Configuration for Database Workloads	2008	SIGMOD	0.00015578896
1,022	DBSherlock: A Performance Diagnostic Tool for Transactional Databases	2016	SIGMOD	0.00014614917
1,092	E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems	2015	VLDB	0.00014135961
1,827	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00010390548
1,902	Black or White? How to Develop an AutoTuner for Memory-based Analytics	2020	SIGMOD	0.00010157713
1,956	D-Bot: Database Diagnosis System using Large Language Models	2024	VLDB	9.960627e-05
3,098	Oracle Database Replay	2008	SIGMOD	7.5646066e-05
4,152	openGauss: An Autonomous Database System	2021	VLDB	6.4060406e-05
4,240	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	6.3318228e-05
4,399	HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements	2022	SIGMOD	6.2225151e-05
4,842	Towards Dynamic and Safe Configuration Tuning for Cloud Databases	2022	SIGMOD	5.8826802e-05
4,868	DBPA: A Benchmark for Transactional Database Performance Anomalies	2023	SIGMOD	5.8629636e-05
4,936	Why Did My Query Slow Down?	2009	CIDR	5.8193534e-05
6,124	iQCAR: inter-Query Contention Analyzer for Data Analytics Frameworks	2019	SIGMOD	5.1988046e-05
6,268	Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems	2019	VLDB	5.133857e-05
6,297	Towards instance-optimized data systems	2021	VLDB	5.1227886e-05
6,765	Automatic Database Configuration Debugging using Retrieval-Augmented Language Models	2025	SIGMOD	4.9325583e-05
7,010	QueryScope: Visualizing Queries for Repeatable Database Tuning	2008	VLDB	4.8634875e-05
7,329	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	4.7610574e-05
8,426	Avoiding Read Stalls on Flash Storage	2022	SIGMOD	4.5162792e-05
8,435	Your Read is Our Priority in Flash Storage	2022	VLDB	4.5139996e-05
10,244	DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs	2026	VLDB	4.1945683e-05
10,822	DBPecker: A Graph-Based Compound Anomaly Diagnosis System for Distributed RDBMSs	2025	VLDB	4.1945683e-05
10,931	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.1945683e-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
527	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.00020868847
846	Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering	2002	VLDB	0.00015997985
1,810	SQL Memory Management in Oracle9i	2002	VLDB	0.0001047003
2,065	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6410693e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,021	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB	7.6991391e-05
2,065	Towards Automated Performance Tuning For Complex Workloads	1994	VLDB	9.6410693e-05
9,141	Automatic SQL Error Mitigation in Oracle	2023	VLDB	4.3855791e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
7,597	Oracle Workload Intelligence	2015	SIGMOD	4.7007801e-05
1,827	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00010390548
4,266	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.30862e-05
10,774	Automatic Indexing in Oracle	2025	VLDB	4.1945683e-05
6,520	Foundations of Automated Database Tuning	2006	VLDB	5.0307595e-05
496	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00021728655