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,571 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.0773174e-05 |
| 7,127 | Guided automated learning for query workload re-optimization | 2019 | VLDB | 4.8230386e-05 |
| 9,141 | Automatic SQL Error Mitigation in Oracle | 2023 | VLDB | 4.3855791e-05 |
| 10,271 | OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning | 2026 | VLDB | 4.1945683e-05 |
| 11,084 | Presto’s History-based Query Optimizer | 2024 | VLDB | 4.1945683e-05 |
| 11,398 | AutoDI: Towards an Automatic Plan Regression Analysis | 2022 | VLDB | 4.1945683e-05 |
| 12,291 | Visualizing the robustness of query execution | 2009 | CIDR | 4.1945683e-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 |
|---|---|---|---|---|
| 339 | Optimization of Dynamic Query Evaluation Plans | 1994 | SIGMOD | 0.00026851113 |
| 1,070 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014316791 |
| 6,561 | On the Stability of Plan Costs and the Costs of Plan Stability | 2010 | VLDB | 5.0099895e-05 |
| 220 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033194808 |
| 4,266 | Parallel SQL Execution in Oracle 10g | 2004 | SIGMOD | 6.30862e-05 |
| 4,571 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.0773174e-05 |
| 5,186 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB | 5.6400929e-05 |
| 7,415 | Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g | 2008 | SIGMOD | 4.7355557e-05 |
| 496 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021728655 |
| 6,139 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 5.1912675e-05 |