Which three must be true for a Smart Scan to occur for a table?
A.
cell_offload_processing must be true in sessions issuing SQL statements that access the table.
B.
The query must be executed serially.
C.
The query must be executed in parallel.
D.
Direct path reads must be used at run time.
E.
The ASM diskgroup containing the table’s tablespace must have a 4 Mbyte AU size.
F.
The ASM diskgroup containing the table’s tablespace must have cell.smart_scan_capable set to true.
Explanation:
A: pt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.
Incorrect Answers:
B, C: The query can run either serially or in parallel.
References: http://blog.tanelpoder.com/2013/05/29/forcing-smart-scans-on-exadata-is-_serial_direct_readparameter-safe-to-use-in-production/