Understanding Exadata Smart Scans
What is a Smart Scan? In a traditional Oracle database, the database server requests blocks from storage. In Exadata, the “intelligence” is moved to the storage cells… -- You can even add SQL snippets like this: SELECT /*+ monitor */ * FROM big_table WHERE column_id = 100;