This discussion is archived
1 Reply Latest reply: Dec 5, 2012 1:27 AM by 589360 RSS

When is it Advanced Compression ? What about HCC?

913089 Newbie
Currently Being Moderated
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 ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points