Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g
Summary: Oracle 11g's SQL Plan Management enforces stability by retaining proven plans and only adopting verifiably better ones. Integrated with the optimizer, it offers CLI/GUI access and delivers stable, optimal performance with no regressions on real workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Mohamed Ziauddin (Oracle)
- 2. Dinesh Das (Oracle)
- 3. Hong Su (Oracle)
- 4. Yali Zhu (Oracle)
- 5. Khaled Yagoub (Oracle)
BibTeX Citation
@article{ziauddin_vldb08,
title = {{Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g}},
author = {Ziauddin, Mohamed and Das, Dinesh and Su, Hong and Zhu, Yali and Yagoub, Khaled},
journal = {PVLDB},
series = {{VLDB} '08},
volume = {1},
number = {2},
pages = {1346--1357},
doi = {10.14778/1454159.1454175},
url = {https://doi.org/10.14778/1454159.1454175},
year = {2008}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,234 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.7134191e-05 |
| 6,764 | Guided automated learning for query workload re-optimization | 2019 | VLDB | 5.6873334e-05 |
| 9,113 | Presto’s History-based Query Optimizer | 2024 | VLDB | 5.2276066e-05 |
| 9,350 | Automatic SQL Error Mitigation in Oracle | 2023 | VLDB | 5.1891342e-05 |
| 10,741 | OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning | 2026 | VLDB | 4.9793485e-05 |
| 10,928 | Real-time SQL Plan Management in Oracle | 2026 | VLDB | 4.9793485e-05 |
| 11,904 | AutoDI: Towards an Automatic Plan Regression Analysis | 2022 | VLDB | 4.9793485e-05 |
| 12,777 | Visualizing the robustness of query execution | 2009 | CIDR | 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 | 996 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB |
| 2 | 5,988 | On the Stability of Plan Costs and the Costs of Plan Stability | 2010 | VLDB |
| 3 | 149 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD |
| 4 | 4,708 | Parallel SQL Execution in Oracle 10g | 2004 | SIGMOD |
| 5 | 4,260 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB |
| 6 | 4,234 | Adaptive Statistics in Oracle 12c | 2017 | VLDB |
| 7 | 7,510 | Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g | 2008 | SIGMOD |
| 8 | 529 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB |
| 9 | 5,442 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB |
| 10 | 10,928 | Real-time SQL Plan Management in Oracle | 2026 | VLDB |