Example 3: 5 total CA groups, 4 selected for processing

CA spill file example 3.

  • 10 input logs
  • 5 total CA groups
  • 4 CA groups selected for processing
  • 2 parallel sort address spaces

Assuming that log records are evenly distributed across all groups, then each group represents 20% memory, and the remaining 2 groups use spill files.

Each spill file contains approximately the volume of 2 input logs (.2 * 10). Therefore, the total spill file requirement would be twice that value.