Why Smart Scan Is the Heart of Oracle Exadata Performance

 How Exadata Storage Offloading Reduces CPU Load and Accelerates Query Processing

Oracle Exadata is designed to deliver extreme database performance, and one of its most powerful innovations is Smart Scan. This feature fundamentally changes how data is processed by shifting intensive workload from the database server to the storage layer.

In simple terms, Smart Scan moves heavy data filtering work closer to the storage, allowing Exadata to process large volumes of data faster and more efficiently.

---

What is Smart Scan?

Smart Scan is an Exadata feature that enables SQL processing to be offloaded to storage servers (cells) instead of processing everything on database servers.

When a query performs a full segment scan, such as:

• Full Table Scan

• Fast Full Index Scan

• Bitmap Index Full Scan

Exadata storage servers process portions of the SQL request directly at the storage layer.

Storage Cells Perform:

• Predicate Filtering

• Column Projection

• Data Reduction

Only the relevant result set is returned to the database server, dramatically reducing unnecessary data movement.

This processing occurs through the iDB (Intelligent Database) protocol, which enables tight integration between the database and storage servers.

---

Why Smart Scan Matters

Traditional database systems transfer entire blocks from storage to database memory, even if only a small portion of data is required.

Smart Scan eliminates this inefficiency by:

• Processing data closer to storage

• Reducing data transfer volume

• Lowering CPU usage on database nodes

---

Requirements for Smart Scan

Smart Scan is enabled by default in Exadata environments, but certain prerequisites must be met.

1. Parameter Requirement

CELL_OFFLOAD_PROCESSING = TRUE

2. ASM Compatibility Requirements

• compatible.rdbms ≥ 11.2

• compatible.asm ≥ 11.2

• cell.smart_scan_capable = TRUE

---

When Smart Scan is Bypassed

Although Smart Scan is highly efficient, it does not apply to every scenario. It may be bypassed under the following conditions:

• Index Organized Tables (IOT)

• Clustered Tables

• Encrypted Tablespaces where storage-level decryption is disabled

• Fast Full Scan on compressed or reverse key indexes

• Queries retrieving LOB or LONG columns

---

Key Benefits of Smart Scan

1. Reduced CPU Load

Database servers process fewer rows and columns, significantly lowering CPU consumption.

2. Reduced Network Traffic

Only filtered and projected data is returned, minimizing data transfer between storage and database nodes.

3. Faster Query Performance

Large analytical queries benefit greatly from reduced I/O and processing overhead.

---

Why Execution Plans May Show Mixed Smart Scan and Non-Smart Scan I/O

Sometimes execution plans indicate Smart Scan usage, yet non-Smart Scan I/O may still occur. This can happen due to several reasons:

• Storage server cannot confirm block freshness, requiring buffer cache reads

• Storage CPU is busier than compute CPU

• Required data already exists in buffer cache

• Chained or migrated rows require additional block access

---

Smart Scan Architecture Advantage

Smart Scan represents a shift from traditional database architecture where storage simply delivers data blocks. In Exadata, storage becomes an active participant in SQL processing.

This distributed workload model significantly enhances performance for:

• Data warehouse workloads

• Reporting systems

• Analytical queries

• Large OLTP systems with heavy read operations

---

Final Thoughts

Smart Scan embodies the core design philosophy of Exadata — process data where it resides.

By reducing unnecessary data movement, minimizing CPU utilization, and accelerating query execution, Smart Scan plays a central role in delivering Exadata’s industry-leading performance.

In simple terms:

👉 Smart Scan means doing less work
👉 Moving less data
👉 Completing queries faster

And that is exactly why Exadata excels in handling large, data-intensive workloads.