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: 9128
Venue: VLDB
Year: 2004
Pagerank: 0.00021728655
Overall Rank: 496 | 96.56%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 33 of 33 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
711	A Case for A Collaborative Query Management System	2009	CIDR	0.00017751589
1,017	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014634307
1,343	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.00012482538
1,534	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	0.00011468393
1,855	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00010315245
2,047	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	9.6920209e-05
2,787	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.1263608e-05
2,828	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.0548516e-05
3,072	Constrained Physical Design Tuning	2008	VLDB	7.6114086e-05
3,142	Active Learning for ML Enhanced Database Systems	2020	SIGMOD	7.4815444e-05
3,169	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	7.4498425e-05
3,284	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2790444e-05
3,354	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.1837096e-05
3,408	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.1288167e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
4,623	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.0411909e-05
4,936	Why Did My Query Slow Down?	2009	CIDR	5.8193534e-05
5,113	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	5.687445e-05
5,376	Holistic Indexing in Main-memory Column-stores	2015	SIGMOD	5.5417421e-05
5,581	CliffGuard: A Principled Framework for Finding Robust Database Designs	2015	SIGMOD	5.424205e-05
5,924	HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning	2023	VLDB	5.2719183e-05
6,398	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	5.0819209e-05
7,127	Guided automated learning for query workload re-optimization	2019	VLDB	4.8230386e-05
8,272	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	4.5452316e-05
8,391	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	4.5287897e-05
9,141	Automatic SQL Error Mitigation in Oracle	2023	VLDB	4.3855791e-05
9,579	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	4.3236869e-05
9,851	Adaptive Schema Databases	2017	CIDR	4.2721228e-05
10,774	Automatic Indexing in Oracle	2025	VLDB	4.1945683e-05
11,071	Index Advisors on Quantum Platforms	2024	VLDB	4.1945683e-05
12,422	The Data Ring: Community Content Sharing	2007	CIDR	4.1945683e-05
12,446	A Framework for Enforcing Application Policies in Database Systems	2007	SIGMOD	4.1945683e-05
12,450	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.1945683e-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	Pagerank
7,597	Oracle Workload Intelligence	2015	SIGMOD	4.7007801e-05
7,415	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	4.7355557e-05
3,284	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2790444e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
9,141	Automatic SQL Error Mitigation in Oracle	2023	VLDB	4.3855791e-05
6,520	Foundations of Automated Database Tuning	2006	VLDB	5.0307595e-05
4,512	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB	6.1241619e-05
10,774	Automatic Indexing in Oracle	2025	VLDB	4.1945683e-05
4,266	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.30862e-05
765	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00017016449