6.3.7 Monitoring Smart I/O

Exadata Smart Scan offloads data search and retrieval processing to the Exadata storage servers. It is able to evaluate database predicates on the storage server to optimize efficiency and performance, especially for large queries and certain classes of bulk data processing.

Smart Scan also uses storage indexes, which are maintained automatically on the storage servers, to further optimize filtering by eliminating unnecessary I/O.

Columnar cache is another smart I/O optimization. The columnar cache is a section of Exadata Smart Flash Cache that stores data in columnar format. The columnar cache is automatically populated and maintained by the storage server when a Smart Scan is performed.

• Monitoring Smart I/O Using AWR
  
• Monitoring Smart I/O Using Database Statistics and Wait Events
  
• Monitoring Smart I/O Using SQL Monitor
  
• Monitoring Smart I/O Using SQL Explain Plan
  
• Monitoring Smart I/O Using Exadata Metrics
  
• What to Look For When Monitoring Smart I/O