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)

Paper ID: 9950
Venue: VLDB
Year: 2008
Pagerank: 6.5928815e-05
Overall Rank: 4,635 | 68.21%
DOI: 10.14778/1454159.1454175

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 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,277	Adaptive Statistics in Oracle 12c	2017	VLDB	6.7873816e-05
6,938	Guided automated learning for query workload re-optimization	2019	VLDB	5.733869e-05
9,240	Automatic SQL Error Mitigation in Oracle	2023	VLDB	5.3004142e-05
10,559	OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning	2026	VLDB	5.093636e-05
11,290	Presto’s History-based Query Optimizer	2024	VLDB	5.093636e-05
11,596	AutoDI: Towards an Automatic Plan Regression Analysis	2022	VLDB	5.093636e-05
12,486	Visualizing the robustness of query execution	2009	CIDR	5.093636e-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
1	289	Optimization of Dynamic Query Evaluation Plans	1994	SIGMOD
2	984	Analyzing Plan Diagrams of Database Query Optimizers	2005	VLDB
3	5,898	On the Stability of Plan Costs and the Costs of Plan Stability	2010	VLDB
4	151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD
5	4,633	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
6	4,416	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB
7	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB
8	7,377	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD
9	524	Automatic SQL Tuning in Oracle 10g	2004	VLDB
10	5,770	Closing The Query Processing Loop in Oracle 11g	2008	VLDB