Automatic SQL Error Mitigation in Oracle
Summary: Automatic in-DB interception of SQL compilation (optimization/codegen) errors and transparent recompilation using identified workarounds. Three mitigation strategies—fall back to historical plans, inject optimizer-context-derived hints, or tweak global optimizer config; implemented in Oracle Autonomous Database. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,999 | Keep It Simple: Testing Databases via Differential Query Plans | 2024 | SIGMOD | 5.7638722e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 8 of 8 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 183 | Automatic Database Management System Tuning Through Large-scale Machine Learning | 2017 | SIGMOD | 0.00036859633 |
| 208 | Schism: a Workload-Driven Approach to Database Replication and Partitioning | 2010 | VLDB | 0.00034478612 |
| 329 | Neo: A Learned Query Optimizer | 2019 | VLDB | 0.00027301488 |
| 495 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021712703 |
| 634 | Bao: Making Learned Query Optimization Practical | 2021 | SIGMOD | 0.00018844568 |
| 2,050 | Automatically Indexing Millions of Databases in Microsoft Azure SQL Database | 2019 | SIGMOD | 9.6883066e-05 |
| 4,513 | Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g | 2008 | VLDB | 6.1183817e-05 |
| 4,621 | Automated Generation of Materialized Views in Oracle | 2020 | VLDB | 6.036749e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,756 | Sampling-Based Query Re-Optimization | 2016 | SIGMOD | 0.00010659753 |
| 3,016 | Adaptive and Big Data Scale Parallel Execution in Oracle | 2013 | VLDB | 7.7060968e-05 |
| 12,117 | Declarative Error Management for Robust Data-Intensive Applications | 2012 | SIGMOD | 4.1905499e-05 |
| 5,547 | Supporting Time-Constrained SQL Queries in Oracle | 2007 | VLDB | 5.4452585e-05 |
| 760 | Automatic Performance Diagnosis and Tuning in Oracle | 2005 | CIDR | 0.00017003914 |
| 10,780 | Automatic Indexing in Oracle | 2025 | VLDB | 4.1905499e-05 |
| 2,503 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB | 8.6306662e-05 |
| 4,621 | Automated Generation of Materialized Views in Oracle | 2020 | VLDB | 6.036749e-05 |
| 4,566 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.073045e-05 |
| 495 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021712703 |