Automatic SQL Error Mitigation in Oracle

Summary: Oracle transparently intercepts compilation-time SQL failures and recompiles queries with automatically selected workarounds. Mitigation uses historical plans, targeted optimizer hints, or global optimizer reconfiguration, enabling seamless execution without user intervention. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 13399
Venue: VLDB
Year: 2023
Pagerank: 5.3004142e-05
Overall Rank: 9,240 | 36.61%
DOI: 10.14778/3611540.3611568

Incoming Non-self Citations Over Time

Authors

1. Krishna Kantikiran Pasupuleti (Oracle)
2. Jiakun Li (Oracle)
3. Hong Su (Oracle)
4. Mohamed Ziauddin (Oracle)

BibTeX Citation

@article{pasupuleti_vldb23,
        title = {{Automatic SQL Error Mitigation in Oracle}},
        author = {Pasupuleti, Krishna Kantikiran and Li, Jiakun and Su, Hong and Ziauddin, Mohamed},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {12},
        pages = {3835--3847},
        doi = {10.14778/3611540.3611568},
        url = {https://doi.org/10.14778/3611540.3611568},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,903	Keep It Simple: Testing Databases via Differential Query Plans	2024	SIGMOD	7.0304586e-05

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
86	Automatic Database Management System Tuning Through Large-scale Machine Learning	2017	SIGMOD	0.00035316107
126	Schism: a Workload-Driven Approach to Database Replication and Partitioning	2010	VLDB	0.00030779127
154	Neo: A Learned Query Optimizer	2019	VLDB	0.00028726181
378	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00019638121
524	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00017120666
1,548	Automatically Indexing Millions of Databases in Microsoft Azure SQL Database	2019	SIGMOD	0.00010392475
4,101	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.9009734e-05
4,635	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB	6.5928815e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,664	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB
2	12,306	Declarative Error Management for Robust Data-Intensive Applications	2012	SIGMOD
3	5,863	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB
4	625	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR
5	10,243	Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction	2026	SIGMOD
6	11,003	Automatic Indexing in Oracle	2025	VLDB
7	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
8	4,101	Automated Generation of Materialized Views in Oracle	2020	VLDB
9	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB
10	524	Automatic SQL Tuning in Oracle 10g	2004	VLDB