Prev Question
Next Question

Which three must he true for Smart Scans to be done?

A.
Executing a query in parallel

B.
Setting _serial_direct_read=true in the session issuing the SQL statements

C.
Having direct path reads used at run time

D.
Having a 4 megAUsize for the ASM diskgroup containing the tablespace in which tables
accessed by a query are stored

E.
Cell_offload_process = true for the ASM diskgroup containing the tablespace in which tables
accessed by a query are stored.

F.
cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables
accessed by a query are stored.

Explanation:
F:ASM Diskgroup has an attribute: cell.smart_scan_capable
• Must be set to TRUE for Smart Scans to work

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *