Parallel SQL Execution in Oracle 10g

Summary: Oracle10g's parallel SQL engine uses a single global parallel plan model, enabling dynamic optimization across grid environments. Built on a shared-disk heritage, the architecture is restructured for efficiency and easier management. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3636
Venue: SIGMOD
Year: 2004
Pagerank: 6.5931076e-05
Overall Rank: 4,633 | 68.22%
DOI: 10.1145/1007568.1007666

Incoming Non-self Citations Over Time

Authors

1. Thierry Cruanes (Oracle)
2. Benoit Dageville (Oracle)
3. Bhaskar Ghosh (Oracle)

BibTeX Citation

@inproceedings{cruanes_sigmod04,
        title = {{Parallel SQL Execution in Oracle 10g}},
        author = {Cruanes, Thierry and Dageville, Benoit and Ghosh, Bhaskar},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007666},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007666},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,794	Distributed Data-Parallel Computing Using a High-Level Programming Language	2009	SIGMOD	9.7399162e-05
2,094	Tupleware: "Big" Data, Big Analytics, Small Clusters	2015	CIDR	9.1819738e-05
4,416	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB	6.7150543e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,291	Managing Intra-operator Parallelism in Parallel Database Systems	1995	VLDB
2	625	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR
3	4,560	Distributed Architecture of Oracle Database In-memory	2015	VLDB
4	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
5	4,635	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB
6	3,036	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD
7	7,377	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD
8	7,324	Architecture of Oracle Parallel Server	1998	VLDB
9	524	Automatic SQL Tuning in Oracle 10g	2004	VLDB
10	2,664	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB