Linux & Oracle DBA Blog
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.
Continue reading “Oracle Exadata Smart Scan”
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.
Continue reading “Exadata HCC Compression”