Real-time SQL Plan Management in Oracle

Summary: Introduces Real-Time SQL Plan Management for Oracle 26ai, moving plan verification from lagging background jobs into query execution. It uses session context to compare new plans immediately, adopting improvements while preventing regressions in cloud and on-premise systems. (summarized by gpt-5.6-luna on Aug 28 2026)

Paper ID: h08281187c1c013d8
Venue: VLDB
Year: 2026
Pagerank: 4.9769913e-05
Overall Rank: 10,937 | 26.50%
DOI: 10.14778/3827998.3828024
PDF: Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Sunil Chakkappen (Oracle)
2. Mohamed Ziauddin (Oracle)
3. Hong Su (Oracle)
4. Shreya Kunjibettu (Oracle)
5. Nigel Bayliss (Oracle Global Services Ltd.)

BibTeX Citation

@article{chakkappen_vldb26,
        title = {{Real-time SQL Plan Management in Oracle}},
        author = {Chakkappen, Sunil and Ziauddin, Mohamed and Su, Hong and Kunjibettu, Shreya and Bayliss, Nigel},
        journal = {PVLDB},
        series = {{VLDB} '26},
        volume = {19},
        number = {12},
        pages = {4169--4181},
        doi = {10.14778/3827998.3828024},
        url = {https://doi.org/10.14778/3827998.3828024},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061067652
4,234	Adaptive Statistics in Oracle 12c	2017	VLDB	6.7104002e-05
4,677	AutoSteer: Learned Query Optimization for Any SQL Database	2023	VLDB	6.4721041e-05
4,711	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB	6.4550597e-05
5,354	Adaptive and Robust Query Execution for Lakehouses at Scale	2024	VLDB	6.1661231e-05
5,447	Closing The Query Processing Loop in Oracle 11g	2008	VLDB	6.1243173e-05
5,700	PilotScope: Steering Databases with Machine Learning Drivers	2024	VLDB	6.028998e-05
6,989	Cackle: Analytical Workload Cost and Performance Stability With Elastic Pools	2023	SIGMOD	5.6257777e-05
7,074	Plan Stitch: Harnessing the Best of Many Plans	2018	VLDB	5.604902e-05
7,356	PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost!	2021	VLDB	5.5421826e-05
7,413	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	5.5316834e-05
8,373	GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints	2026	SIGMOD	5.3427119e-05
8,531	ROME: Robust Query Optimization via Parallel Multi-Plan Execution	2024	SIGMOD	5.3206021e-05
8,779	Automatic Indexing in Oracle	2025	VLDB	5.2781453e-05
9,310	Rethink Query Optimization in HTAP Databases	2023	SIGMOD	5.1963298e-05
9,725	APQO: An Adaptive Framework for Parametric Query Optimization	2026	SIGMOD	5.1325223e-05
9,735	PAR2QO: Parametric Penalty-Aware Robust Query Optimization	2025	VLDB	5.1325223e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,007	Automated Generation of Materialized Views in Oracle	2020	VLDB
2	4,258	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB
3	2,529	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB
4	4,234	Adaptive Statistics in Oracle 12c	2017	VLDB
5	5,983	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB
6	598	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR
7	4,710	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
8	529	Automatic SQL Tuning in Oracle 10g	2004	VLDB
9	8,779	Automatic Indexing in Oracle	2025	VLDB
10	4,711	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB