Forum Stats

  • 3,840,065 Users
  • 2,262,563 Discussions
  • 7,901,143 Comments

Discussions

When is it Advanced Compression ? What about HCC?

User_3OVQO
User_3OVQO Member Posts: 21 Employee
edited Dec 5, 2012 4:27AM in Advanced Compression
The below is from the Admin Guide
Note: Hybrid Columnar Compression is dependent on the
underlying storage system. See Oracle Database Licensing Information
for more information.

The below is from the Oracle® Database PL/SQL Packages and Types Reference
Compression Constant Compression Level Description
COMP_FOR_OLTP 2 OLTP compression
COMP_FOR_QUERY_HIGH 4 High compression level for query operations
COMP_FOR_QUERY_LOW 8 Low compression level for query operations
COMP_FOR_ARCHIVE_HIGH 16 High compression level for archive operations
COMP_FOR_ARCHIVE_LOW 32 Low compression level for archive operations

To use Compression Level 4 or higher do we have to have ZFS or Pillar storage ?

Answers

This discussion has been closed.