What is Smart Scan?
Smart Scan is one of the great feature in Oracle Exadata. With this technology storage send only required rows to database node from storage instead of entire Oracle Block. Multiple rows are stored in one Oracle Block but non-exadata system return entire block even only one rows is required. On the other hand, Exadata Storage returns only interested rows but not entire block.Continue reading