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
- 2. Dinesh Das
- 3. Hong Su
- 4. Yali Zhu
- 5. Khaled Yagoub
Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,566 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.073045e-05 |
| 7,126 | Guided automated learning for query workload re-optimization | 2019 | VLDB | 4.8184704e-05 |
| 9,141 | Automatic SQL Error Mitigation in Oracle | 2023 | VLDB | 4.382234e-05 |
| 10,271 | OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning | 2026 | VLDB | 4.1905499e-05 |
| 11,087 | Presto’s History-based Query Optimizer | 2024 | VLDB | 4.1905499e-05 |
| 11,401 | AutoDI: Towards an Automatic Plan Regression Analysis | 2022 | VLDB | 4.1905499e-05 |
| 12,299 | Visualizing the robustness of query execution | 2009 | CIDR | 4.1905499e-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 | Pagerank |
|---|---|---|---|---|
| 342 | Optimization of Dynamic Query Evaluation Plans | 1994 | SIGMOD | 0.00026836424 |
| 1,064 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014348262 |
| 6,561 | On the Stability of Plan Costs and the Costs of Plan Stability | 2010 | VLDB | 5.0055336e-05 |
| 221 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033182072 |
| 4,260 | Parallel SQL Execution in Oracle 10g | 2004 | SIGMOD | 6.3033486e-05 |
| 5,184 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB | 5.6360141e-05 |
| 4,566 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.073045e-05 |
| 7,414 | Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g | 2008 | SIGMOD | 4.7312542e-05 |
| 495 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021712703 |
| 6,142 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 5.186791e-05 |