Multiple choice technology databases

Predicate evaluation is not offloaded to Exadata Cell in the following cases:

  1. The CELL_OFFLOAD_PROCESSING parameter is set to FALSE.

  2. The CELL_OFFLOAD_PROCESSING parameter is set to TRUE

  3. The table or partition being scanned is small.

  4. The optimizer does not use direct path read.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Exadata Smart Scan offloading is bypassed if disabled via CELL_OFFLOAD_PROCESSING = FALSE, if a direct path read is not used by the optimizer (smart scans require direct path reads), or if the scanned segment is too small.

Keep practicing — related questions