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: hca100088b285ee31
Venue: VLDB
Year: 2004
Pagerank: 0.0001681305
Overall Rank: 532 | 96.44%
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
756	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014209974
1,072	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.00012143482
1,166	A Case for A Collaborative Query Management System	2009	CIDR	0.00011705174
1,282	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00011197535
1,517	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	0.00010385462
1,706	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	9.804657e-05
2,169	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	8.9151935e-05
2,290	Active Learning for ML Enhanced Database Systems	2020	SIGMOD	8.6813363e-05
2,381	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.5299827e-05
2,784	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.0021123e-05
2,864	Constrained Physical Design Tuning	2008	VLDB	7.9087048e-05
2,888	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.8895201e-05
3,050	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.6969161e-05
3,114	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.6194936e-05
4,022	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.8345671e-05
4,252	Adaptive Statistics in Oracle 12c	2017	VLDB	6.6894038e-05
4,701	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	6.44638e-05
5,037	Why Did My Query Slow Down?	2009	CIDR	6.2907346e-05
5,149	Holistic Indexing in Main-memory Column-stores	2015	SIGMOD	6.2382463e-05
5,272	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	6.1887235e-05
5,324	CliffGuard: A Principled Framework for Finding Robust Database Designs	2015	SIGMOD	6.1645235e-05
5,687	HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning	2023	VLDB	6.0201937e-05
6,779	Guided automated learning for query workload re-optimization	2019	VLDB	5.6686556e-05
7,424	Index Advisors on Quantum Platforms	2024	VLDB	5.5148364e-05
8,780	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.2650571e-05
8,798	Automatic Indexing in Oracle	2025	VLDB	5.2606925e-05
8,892	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	5.2420764e-05
9,385	Automatic SQL Error Mitigation in Oracle	2023	VLDB	5.1697992e-05
9,895	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	5.1000511e-05
10,216	Adaptive Schema Databases	2017	CIDR	5.0468526e-05
12,954	The Data Ring: Community Content Sharing	2007	CIDR	4.9605343e-05
12,978	A Framework for Enforcing Application Policies in Database Systems	2007	SIGMOD	4.9605343e-05
12,982	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.9605343e-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,534	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD
2	10,998	Real-time SQL Plan Management in Oracle	2026	VLDB
3	3,050	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD
4	4,252	Adaptive Statistics in Oracle 12c	2017	VLDB
5	9,385	Automatic SQL Error Mitigation in Oracle	2023	VLDB
6	6,265	Foundations of Automated Database Tuning	2006	VLDB
7	4,724	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB
8	8,798	Automatic Indexing in Oracle	2025	VLDB
9	4,721	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
10	583	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR