CHAPTER 15

image

Smart Scan and Cell Offload

Smart Scan is probably the most important performance component in Exadata’s software offering in terms of delivering extreme performance. Smart Scan is a cell offload feature whose goal is to offload processing to storage cells instead of performing block I/O requests in the database tier. The goal of Smart Scan processing is to do all the “heavy lifting”, I/O-wise, in the storage cell and only send back data to the compute nodes that is actually needed and requested. This reduces interconnect traffic between the storage grid and database tier, reduces the clutter in the database buffer cache, improves ...

Get Oracle Exadata Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.