1Z0-536 · Question #25
You want to understand which SQL statements have been executing using Smart Scan capabilities. Where can you look for this information?
The correct answer is B. Query statistics from the V$ views. The Exadata storage provides several unique performance-enhancing features including smart scan, storage index and Exadata Hybrid Columnar Compression. Monitoring these features can be easily done via the Gv$ performance views or Oracle Enterprise Manager. You can check if…
Question
You want to understand which SQL statements have been executing using Smart Scan capabilities. Where can you look for this information?
Exhibit
Options
- AYou can infer from the performance of the statement.
- BQuery statistics from the V$ views
- CThe hints used in a SQL statement
- DWith the CELLCLI SMART.SQL statement
How the community answered
(39 responses)- A3% (1)
- B79% (31)
- C13% (5)
- D5% (2)
Explanation
The Exadata storage provides several unique performance-enhancing features including smart scan, storage index and Exadata Hybrid Columnar Compression. Monitoring these features can be easily done via the Gv$ performance views or Oracle Enterprise Manager. You can check if smart scan offloading has taken place or not and how much data got reduced by querying either the V$ views or by using the SQL Monitoring capabilities of Enterprise Manager. For example you can query IO_CELL_OFFLOAD_ELIGIBLE_BYTES from V$SQL to see if you query is eligible for query offload.
Topics
Community Discussion
No community discussion yet for this question.