Basic HTML version of Foils prepared 7 October 97

Foil 35 Example of parallel execution of a full scan

From Second Part of RDBMS Discussion ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou
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.2
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

© on Mon Oct 13 1997