Adaptive and Big Data Scale Parallel Execution in Oracle

Summary: Oracle’s adaptive parallel execution uses multi-stage plans and runtime data/statistics to correct optimizer errors and dynamically choose parallelism and distribution for joins, aggregates, rollups, and windows. It also parallelizes inherently serial operators at big-data scale. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 10736
Venue: VLDB
Year: 2013
Pagerank: 8.2816537e-05
Overall Rank: 2,664 | 81.73%
DOI: 10.14778/2536222.2536235

Incoming Non-self Citations Over Time

Authors

1. Srikanth Bellamkonda (Oracle)
2. Hua-Gang Li (Oracle)
3. Unmesh Jagtap (Oracle)
4. Yali Zhu (Oracle)
5. Vince Liang (Oracle)
6. Thierry Cruanes (Oracle)

BibTeX Citation

@article{bellamkonda_vldb13,
        title = {{Adaptive and Big Data Scale Parallel Execution in Oracle}},
        author = {Bellamkonda, Srikanth and Li, Hua-Gang and Jagtap, Unmesh and Zhu, Yali and Liang, Vince and Cruanes, Thierry},
        journal = {PVLDB},
        series = {{VLDB} '13},
        volume = {6},
        number = {11},
        pages = {1102--1113},
        doi = {10.14778/2536222.2536235},
        url = {https://doi.org/10.14778/2536222.2536235},
        year = {2013}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
241	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023654664
3,673	Efficient Processing of Window Functions in Analytical SQL Queries	2015	VLDB	7.2113383e-05
7,915	Krypton: Real-time Serving and Analytical SQL Engine at ByteDance	2023	VLDB	5.5181056e-05
8,850	Learning-based Property Estimation with Polynomials	2024	SIGMOD	5.3577504e-05
10,096	Out-of-order Execution of Database Queries	2020	VLDB	5.1523392e-05
11,466	Anser: Adaptive Information Sharing Framework of AnalyticDB	2023	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071822821
207	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00025088003
209	Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs	2009	VLDB	0.00024932174
1,657	Handling Data Skew in Parallel Joins in Shared-Nothing Systems	2008	SIGMOD	0.00010096933
2,021	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	9.297379e-05
2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB	9.1803718e-05
4,020	Optimization of Analytic Window Functions	2012	VLDB	6.9513881e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,104	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
2	3,726	Parallelizing Query Optimization	2008	VLDB
3	7,689	Oracle In-Database Hadoop: When MapReduce Meets RDBMS	2012	SIGMOD
4	1,291	Managing Intra-operator Parallelism in Parallel Database Systems	1995	VLDB
5	11,297	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB
6	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
7	1,320	From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System	2015	SIGMOD
8	1,596	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD
9	3,036	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD
10	4,633	Parallel SQL Execution in Oracle 10g	2004	SIGMOD