Fernando - Root Fan

December 16, 2024December 17, 2024

Oracle Exadata Smart Scan

corn fields under white clouds with blue sky during daytime

Smart Scan is a feature in Oracle’s Exadata platform that allows certain types of operations to be offloaded from the database server to the Exadata storage servers, dramatically improving performance by reducing the amount of data that needs to be transferred between storage and the database server.

December 16, 2024December 16, 2024

Exadata HCC Compression

green leafed tree beside body of water during daytime

Hybrid Columnar Compression (HCC) is an advanced compression technology introduced by Oracle, particularly designed for environments like Oracle Exadata.

Unlike traditional row-major format databases, HCC organizes data in a column-major format within storage units known as Compression Units (CUs).

This format allows Oracle to compress data more efficiently, improving both storage utilization and query performance, especially for read-heavy operations such as data warehousing and archiving.