DBScholar

Back to papers

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.00016866092
Overall Rank
529 | 96.45%
DOI
10.1016/B978-012088469-8.50096-6

Incoming Non-self Citations Over Time

Authors

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
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.0001425375
1,069 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012185253
1,164 A Case for A Collaborative Query Management System 2009 CIDR 0.00011745383
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011226878
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010402594
1,708 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.8224587e-05
2,250 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7533306e-05
2,275 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7090584e-05
2,373 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.5606392e-05
2,775 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0312847e-05
2,857 Constrained Physical Design Tuning 2008 VLDB 7.9380294e-05
2,891 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9021718e-05
3,041 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.7215151e-05
3,103 An Object Placement Advisor for DB2 Using Solid State Storage 2009 VLDB 7.6482159e-05
4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8592987e-05
4,234 Adaptive Statistics in Oracle 12c 2017 VLDB 6.7134191e-05
4,690 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4687131e-05
5,033 Why Did My Query Slow Down? 2009 CIDR 6.3049311e-05
5,131 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2602133e-05
5,248 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.211056e-05
5,316 CliffGuard: A Principled Framework for Finding Robust Database Designs 2015 SIGMOD 6.1836681e-05
5,674 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0430252e-05
6,764 Guided automated learning for query workload re-optimization 2019 VLDB 5.6873334e-05
7,403 Index Advisors on Quantum Platforms 2024 VLDB 5.5357529e-05
8,751 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 5.284914e-05
8,771 Automatic Indexing in Oracle 2025 VLDB 5.2806451e-05
8,865 Divergent Physical Design Tuning for Replicated Databases 2012 SIGMOD 5.2618746e-05
9,350 Automatic SQL Error Mitigation in Oracle 2023 VLDB 5.1891342e-05
9,853 Kaizen: A Semi-Automatic Index Advisor 2012 SIGMOD 5.1193944e-05
10,179 Adaptive Schema Databases 2017 CIDR 5.0659942e-05
12,906 The Data Ring: Community Content Sharing 2007 CIDR 4.9793485e-05
12,930 A Framework for Enforcing Application Policies in Database Systems 2007 SIGMOD 4.9793485e-05
12,934 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

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
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 7,510 Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g 2008 SIGMOD
2 10,928 Real-time SQL Plan Management in Oracle 2026 VLDB
3 3,041 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD
4 4,234 Adaptive Statistics in Oracle 12c 2017 VLDB
5 9,350 Automatic SQL Error Mitigation in Oracle 2023 VLDB
6 6,251 Foundations of Automated Database Tuning 2006 VLDB
7 4,709 Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g 2008 VLDB
8 8,771 Automatic Indexing in Oracle 2025 VLDB
9 4,708 Parallel SQL Execution in Oracle 10g 2004 SIGMOD
10 598 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR