Metraipolis › archive › dc_ff8da4bb259d

Real-time SQL Plan Management in Oracle — arXiv:2608.27758

Source: arXiv (en)
Original: https://arxiv.org/abs/2608.27758
License (as archived): CC0-1.0
Archived: 2026-10-17T11:52:09.126Z
SHA-256 of the archived text: a1e9350a6ed26cfc9091da7dc03653f8d83cd6a5b1792650972420f1f7900850
Stable URL of this page: https://metraipolis.com/documento/dc_ff8da4bb259d

How to cite

Real-time SQL Plan Management in Oracle — arXiv:2608.27758 — arXiv (en), https://arxiv.org/abs/2608.27758 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_ff8da4bb259d (Metraipolis archive dc_ff8da4bb259d, sha256 a1e9350a6ed26cfc9091da7dc03653f8d83cd6a5b1792650972420f1f7900850)

BibTeX

@misc{dcff8da4bb259d,
  title = {Real-time SQL Plan Management in Oracle — arXiv:2608.27758},
  howpublished = {arXiv (en)},
  url = {https://arxiv.org/abs/2608.27758},
  note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_ff8da4bb259d; sha256 a1e9350a6ed26cfc9091da7dc03653f8d83cd6a5b1792650972420f1f7900850},
  year = {2026}
}

Archived text

Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2608.27758. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

Consistent query performance is essential for mission critical database applications, yet SQL execution plans can change due to factors such as database upgrades, DML changes, new indexes, etc. While plan stability mechanisms such as stored outlines prevent regressions by freezing execution plans, they also inhibit performance improvements by disallowing plan evolution. We introduced SQL Plan Management (SPM) in Oracle 11g to address this trade-off by maintaining a set of accepted execution plans and allowing plan evolution only when new plans demonstrably outperform existing baselines. However, prior implementations of SPM primarily rely on background performance verification processes, delaying regression detection and recovery. This issue is amplified in autonomous cloud database systems, where several automatic actions that could cause plan change driven regressions are performed with limited customer control. Timely detection and remediation is paramount, but the constrained background resources on cloud may not keep pace. To overcome these limitations, we introduce Real-Time SPM in Oracle 26ai, a novel extension of SPM that performs foreground verification of new execution plans during user query execution. Real-Time SPM leverages runtime session context to immediately validate plan changes, enabling rapid adoption of superior plans while promptly detecting and preventing regressions. This paper presents the architecture and design of Real-Time SPM - including technical challenges like reliably comparing performance of previous plans - and contrasts it with traditional background plan evolution.

Tema degli esploratori: statistica e scienza dei dati (retro-catalogo arXiv: annunci del 2026-08-31 in cs.DB).
Categorie arXiv: Databases (cs.DB).
Pagina del lavoro: https://arxiv.org/abs/2608.27758 — autori e testo completo sono lì (qui omessi i nomi: nessun dato personale nel deposito).
Licenza: titolo e abstract sono metadati arXiv distribuiti in CC0 1.0; il testo completo ha la licenza scelta dagli autori, indicata sulla pagina.
Letto il 2026-10-17T11:22:25.874Z dalla pagina https://arxiv.org/catchup/cs.DB/2026-08-31?abs=True (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).