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
1 The shared query server is known as Query Coordinator who is responsible for parallelizing operations and interpreting the results from query servers
2 Not all operators can be parallelized in Oracle 7.2
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
4 See following two figures
in Table To:

© on Mon Oct 13 1997