Automatic SQL Tuning in Oracle 10g

Summary: Automatic SQL Tuning in Oracle 10g embeds self-tuning in the optimizer via SQL profiling to improve plans. It delivers cost-based access-path and what-if analyses via GUI/CLI for automated, workload-driven tuning, outperforming manual tuning. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9319
Venue: VLDB
Year: 2004
Pagerank: 0.00017120666
Overall Rank: 524 | 96.41%
DOI: 10.1016/B978-012088469-8.50096-6

Incoming Non-self Citations Over Time

Authors

1. Benoit Dageville (Oracle)
2. Dinesh Das (Oracle)
3. Karl Dias (Oracle)
4. Khaled Yagoub (Oracle)
5. Mohamed Zait (Oracle)
6. Mohamed Ziauddin (Oracle)

BibTeX Citation

@article{dageville_vldb04,
        title = {{Automatic SQL Tuning in Oracle 10g}},
        author = {Dageville, Benoit and Das, Dinesh and Dias, Karl and Yagoub, Khaled and Zait, Mohamed and Ziauddin, Mohamed},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {1098--1109},
        doi = {10.1016/B978-012088469-8.50096-6},
        url = {https://doi.org/10.1016/B978-012088469-8.50096-6},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 33 of 33 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
768	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014173242
1,070	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.0001232307
1,149	A Case for A Collaborative Query Management System	2009	CIDR	0.0001194728
1,279	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00011361878
1,548	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	0.00010392475
1,694	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	9.9953156e-05
2,313	Active Learning for ML Enhanced Database Systems	2020	SIGMOD	8.762627e-05
2,355	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	8.7022189e-05
2,364	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.6869645e-05
2,722	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.206711e-05
2,811	Constrained Physical Design Tuning	2008	VLDB	8.0982817e-05
2,944	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.9335187e-05
3,003	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.8620915e-05
3,055	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.8079566e-05
4,101	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.9009734e-05
4,277	Adaptive Statistics in Oracle 12c	2017	VLDB	6.7873816e-05
4,637	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	6.592197e-05
4,958	Why Did My Query Slow Down?	2009	CIDR	6.428827e-05
5,039	Holistic Indexing in Main-memory Column-stores	2015	SIGMOD	6.3909067e-05
5,222	CliffGuard: A Principled Framework for Finding Robust Database Designs	2015	SIGMOD	6.3103741e-05
5,558	HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning	2023	VLDB	6.1749098e-05
5,766	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	6.094771e-05
6,938	Guided automated learning for query workload re-optimization	2019	VLDB	5.733869e-05
8,601	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.4048965e-05
8,703	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	5.3813751e-05
9,240	Automatic SQL Error Mitigation in Oracle	2023	VLDB	5.3004142e-05
9,715	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	5.2337048e-05
10,003	Adaptive Schema Databases	2017	CIDR	5.1814573e-05
11,003	Automatic Indexing in Oracle	2025	VLDB	5.093636e-05
11,277	Index Advisors on Quantum Platforms	2024	VLDB	5.093636e-05
12,616	The Data Ring: Community Content Sharing	2007	CIDR	5.093636e-05
12,640	A Framework for Enforcing Application Policies in Database Systems	2007	SIGMOD	5.093636e-05
12,644	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,740	Oracle Workload Intelligence	2015	SIGMOD
2	7,377	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD
3	3,003	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD
4	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB
5	9,240	Automatic SQL Error Mitigation in Oracle	2023	VLDB
6	6,131	Foundations of Automated Database Tuning	2006	VLDB
7	4,635	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB
8	11,003	Automatic Indexing in Oracle	2025	VLDB
9	4,633	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
10	625	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR