Which two must be true for a Smart Scan to occur on a table?
Which two must be true for a Smart Scan to occur on a table?
For a Smart Scan to occur on a table, sessions querying the table must set cell_offload_processing to true and the table must be accessed using direct path reads. Cell offload processing allows certain SQL processing work to be offloaded to the storage level, which is a key element of Smart Scan functionality. Additionally, direct path reads are necessary to leverage the Exadata storage for faster data retrieval.
Correct answers: AD For the Smart Scan to work, the SQL you run must have these requirements: • The segment you are querying must be stored in an Exadata Database Machine where the disk group with the cell.smart_scan_capable attribute is set to true. • A Full Table Scan or an Index Fast Full Scan operation must occur. • The segment must be big enough to fire a direct path read operation.