1 Reply Latest reply: Dec 5, 2012 3:27 AM by 589360 RSS

    When is it Advanced Compression ? What about HCC?

    913089
      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 ?