HELP! * GREY=local LOCAL HTML version of Foils prepared July 6,1995

Foil 37 Example of parallel execution of a full scan

From Explicit Examples in Parallel Relational Databases CPS600 Spring Semester -- April 1995. by Gang Cheng Marek Podgorny (Geoffrey Fox) * See also color IMAGE
The shared query server is known as Query Coordinator who is responsible for parallelizing operations and interpreting the results from query servers
Not all operators can be parallelized in Oracle 7.1.3
Oracle Server Parallizable Operations
  • Table Scans
  • Sorts (for ORDER BY, GROUP BY, Joins, DISTINCT)
  • Joins (Sort-Merge, Nested Loops)
  • Aggregates (GROUP BY, MIN, MAX, AVG, etc )
  • SET operations (eg., UNION, INTERSECT or MINUS) are not parallelized
See following two figures

Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Feb 18 1997