Oracle Database Compression 3 - Hybrid Columnar Compression

最新推荐文章于 2021-02-02 20:01:26 发布

chncaesar

最新推荐文章于 2021-02-02 20:01:26 发布

阅读量941

点赞数

分类专栏： Oracle 文章标签：混合列压缩 Hybrid Columnar Comp Exadata

本文链接：https://blog.csdn.net/chncaesar/article/details/17318955

版权

本文详细探讨了Oracle数据库的Hybrid Columnar Compression技术，包括其如何在Compression Unit级别工作，以实现高效的数据存储和检索。对于在Exadata平台上运行的数据库应用，这种压缩方法尤其关键。

摘要由CSDN通过智能技术生成

Hybrid Columnar Compression

Hybrid Columnar Compression is a feature of the Enterprise Edition of Oracle Database 11g that is dependent on the underlying storage system. Only Exadata storage, ZFS storage, and Pillar Axiom 600 storage support Hybrid Columnar Compression.

With Hybrid Columnar Compression, the database stores the same column for a group of rows together.Storing column data together, with the same data type and similar characteristics, dramatically increases the storage savings achieved from compression. The database compresses data manipulated by any SQL operation, although compression levels are higher for direct path loads.

If your underlying storage supports Hybrid Columnar Compression, then you can specify the following compression types, depending on your requirements: