Oracle
1Z0-027 · Question #29
Which three must he true for Smart Scans to be done?
The correct answer is B. Setting _serial_direct_read=true in the session issuing the SQL statements C. Having direct path reads used at run time F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed. ASM Diskgroup has an attribute: cell.smart_scan_capable ?Must be set to TRUE for Smart
Key Capabilities and Features
Question
Which three must he true for Smart Scans to be done?
Options
- AExecuting a query in parallel
- BSetting _serial_direct_read=true in the session issuing the SQL statements
- CHaving direct path reads used at run time
- DHaving a 4 meg AU size for the ASM diskgroup containing the tablespace in which tables accessed
- ECell_offload_process = true for the ASM diskgroup containing the tablespace in which tables accessed
- Fcell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed
How the community answered
(23 responses)- A4% (1)
- B83% (19)
- D4% (1)
- E9% (2)
Explanation
ASM Diskgroup has an attribute: cell.smart_scan_capable ?Must be set to TRUE for Smart
Topics
#Smart Scan prerequisites#direct path reads#cell_smart_scan_capable#serial direct read
Community Discussion
No community discussion yet for this question.