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: 9129
Venue: VLDB
Year: 2004
Pagerank: 0.00021712703
Overall Rank: 495 | 96.57%
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
709	A Case for A Collaborative Query Management System	2009	CIDR	0.00017740603
1,018	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014626746
1,346	NoDB: Efficient Query Execution on Raw Data Files	2012	SIGMOD	0.00012472598
1,533	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	0.00011462982
1,856	AI Meets AI: Leveraging Query Executions to Improve Index Recommendations	2019	SIGMOD	0.00010319105
2,050	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	9.6883066e-05
2,788	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.121027e-05
2,834	Automatic Physical Design Tuning: Workload as a Sequence	2006	SIGMOD	8.0468556e-05
3,077	Constrained Physical Design Tuning	2008	VLDB	7.6043371e-05
3,144	Active Learning for ML Enhanced Database Systems	2020	SIGMOD	7.4844943e-05
3,167	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	7.4561078e-05
3,276	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2880761e-05
3,358	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.1724434e-05
3,402	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.134261e-05
4,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05
4,621	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.036749e-05
4,938	Why Did My Query Slow Down?	2009	CIDR	5.8140945e-05
5,114	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	5.6813929e-05
5,378	Holistic Indexing in Main-memory Column-stores	2015	SIGMOD	5.5379945e-05
5,578	CliffGuard: A Principled Framework for Finding Robust Database Designs	2015	SIGMOD	5.4231783e-05
5,925	HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning	2023	VLDB	5.2669029e-05
6,394	Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty	2022	VLDB	5.0770427e-05
7,126	Guided automated learning for query workload re-optimization	2019	VLDB	4.8184704e-05
8,268	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	4.5408509e-05
8,390	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	4.524666e-05
9,141	Automatic SQL Error Mitigation in Oracle	2023	VLDB	4.382234e-05
9,578	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	4.3195435e-05
9,851	Adaptive Schema Databases	2017	CIDR	4.2680295e-05
10,780	Automatic Indexing in Oracle	2025	VLDB	4.1905499e-05
11,074	Index Advisors on Quantum Platforms	2024	VLDB	4.1905499e-05
12,431	The Data Ring: Community Content Sharing	2007	CIDR	4.1905499e-05
12,455	A Framework for Enforcing Application Policies in Database Systems	2007	SIGMOD	4.1905499e-05
12,459	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.1905499e-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,602	Oracle Workload Intelligence	2015	SIGMOD	4.6964845e-05
7,414	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	4.7312542e-05
3,276	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD	7.2880761e-05
4,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05
9,141	Automatic SQL Error Mitigation in Oracle	2023	VLDB	4.382234e-05
6,494	Foundations of Automated Database Tuning	2006	VLDB	5.0334983e-05
4,513	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB	6.1183817e-05
10,780	Automatic Indexing in Oracle	2025	VLDB	4.1905499e-05
4,260	Parallel SQL Execution in Oracle 10g	2004	SIGMOD	6.3033486e-05
760	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00017003914