You want to understand which SQL statements have been executing using Smart Scan
capabilities. Where can you look for this information?
A.
You can infer from the performance of the statement.
B.
Query statistics from the V$ views
C.
The hints used in a SQL statement
D.
With the CELLCLI SMART.SQL statement
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.
http://www.oracle.com/technetwork/middleware/bi-foundation/twp-dw-best-practices-workloadmgmt-157666.pdf
