If the number of leaf blocks of index , scanned is 50000-250000 then what is the degree of parallelism is 16 ?
-
True
-
False
Similar to the previous question, there is no fixed rule that 50000-250000 leaf blocks automatically equals degree 16 parallelism. The degree of parallelism is calculated by the optimizer based on multiple factors including system resources, operation cost, and initialization parameters, not just block count ranges.
Oracle's automatic degree of parallelism (Auto DOP) sizing uses the number of leaf blocks an index scan would touch to estimate an appropriate DOP, based on internal thresholds tied to PARALLEL_THRESHOLD and I/O calibration — but the specific claim that a 50,000–250,000 leaf-block range always yields exactly DOP 16 is not a fixed, documented rule; actual DOP depends on the calibrated hardware I/O rate, PARALLEL_DEGREE_LIMIT, and other settings, not a single static leaf-block bracket. So the statement as an absolute rule is False — DOP scales with system-specific calibration, not a fixed leaf-block-to-DOP lookup table.