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 |
|---|---|---|---|---|
| 5,037 | Keep It Simple: Testing Databases via Differential Query Plans | 2024 | SIGMOD | 5.7434825e-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.00036721403 |
| 209 | Schism: a Workload-Driven Approach to Database Replication and Partitioning | 2010 | VLDB | 0.00034468292 |
| 333 | Neo: A Learned Query Optimizer | 2019 | VLDB | 0.00027206884 |
| 496 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021728655 |
| 640 | Bao: Making Learned Query Optimization Practical | 2021 | SIGMOD | 0.00018759152 |
| 2,047 | Automatically Indexing Millions of Databases in Microsoft Azure SQL Database | 2019 | SIGMOD | 9.6920209e-05 |
| 4,512 | Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g | 2008 | VLDB | 6.1241619e-05 |
| 4,623 | Automated Generation of Materialized Views in Oracle | 2020 | VLDB | 6.0411909e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,758 | Sampling-Based Query Re-Optimization | 2016 | SIGMOD | 0.00010655546 |
| 3,021 | Adaptive and Big Data Scale Parallel Execution in Oracle | 2013 | VLDB | 7.6991391e-05 |
| 12,109 | Declarative Error Management for Robust Data-Intensive Applications | 2012 | SIGMOD | 4.1945683e-05 |
| 5,539 | Supporting Time-Constrained SQL Queries in Oracle | 2007 | VLDB | 5.4503121e-05 |
| 765 | Automatic Performance Diagnosis and Tuning in Oracle | 2005 | CIDR | 0.00017016449 |
| 10,774 | Automatic Indexing in Oracle | 2025 | VLDB | 4.1945683e-05 |
| 2,504 | Enhanced Subquery Optimizations in Oracle | 2009 | VLDB | 8.6351917e-05 |
| 4,623 | Automated Generation of Materialized Views in Oracle | 2020 | VLDB | 6.0411909e-05 |
| 4,571 | Adaptive Statistics in Oracle 12c | 2017 | VLDB | 6.0773174e-05 |
| 496 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021728655 |