FS System: How to Enable Oracle Hybrid Columnar Compression (HCC) on the FS1-2

Asset ID:	1-71-2116491.1
Update Date:	2018-01-04
Keywords:

Solution Type Technical Instruction Sure

Solution 2116491.1 : FS System: How to Enable Oracle Hybrid Columnar Compression (HCC) on the FS1-2

Applies to:

Oracle FS1-2 Flash Storage System - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Goal

This article describes how to enable Oracle Hybrid Columnar Compression (HCC) for FS1-2 with ASM/RDBMS 12.1.0.2.0.

This article is based on content provided by Larry Tudor.

Solution

HCC is NOT supported:
- on any NAS or Direct NFS implementations at this time.
- with Solaris Kernel Zone Virtualization.

HCC is supported on:
- any supported versions of ASM, ASMLIB and ASMFD.

Platforms Verified:

Oracle Enterprise Linux 6.7 and 7.2 x86_64
Solaris Sparc and x86 version 11.1
Windows 2008 R2 and Windows 2012 R2 x86_64

Please see Oracle Flash Storage Support and Interoperability Guide for updates.

Oracle Flash Storage System Support and Interoperability Guide

How to Enable HCC

HCC is enabled by means of a system call by ASM to determine the vendor ID. ASM is a prerequisite to enabling HCC on the database.

The syntax to enable HCC for the diskgroup +DATA would be:

[grid@<hostname> ~]$ sqlplus / as sysasm
set echo on
set verify on
set feedback on
ALTER diskgroup DATA SET attribute 'compatible.ASM'='12.1.0.2.0';
ALTER diskgroup DATA SET attribute 'compatible.rdbms'='12.1.0.2.0';
ALTER diskgroup DATA SET attribute 'storage.type'='AXIOM';

The ASM alert log will also confirm the success once HCC is enabled and diskgroup is altered.

In Oracle 12.1 there are no commands or parameters that need to be set in the Database to begin using HCC.

NOTE: No child processes can be connected to the diskgroup that is being modified. In Oracle 12.1 grid/ASM install there is a new Management DB that is installed during the grid install. Since this "MGMTDB" process needs to be running to login 'as sysasm' it is recommended that the diskgroup you use for the database(s) and HCC be on a separate diskgroup.

NOTE: It is is highly recommended that grid/ASM and the Oracle RDBMS database product be patched to the latest patch release after the initial installs.

Best practices to implement HCC:

Install grid/ASM to a small diskgroup of 10 to 20 GB and name is something different than the default of +DATA
After the installation of ASM install patch(es) the grid product
Create the +DATA diskgroup
Perform the sqlplus alter statements on 'DATA' given above at "How to Enable HCC" section.

NOTE: An error may be returned when enabling HCC on ASM diskgroups that have been partitioned or formatted as a file system. The solution is to present the raw LUNs to ASM for diskgroups that are intended to be used with HCC.
Please refer to <Document 2162812.1> FS System: Get ORA-15032, ORA-15242, ORA-15287 errors when enable HCC Compression On Flash Storage FS1

For FS1 white page documentation, please visit the following page:

http://www.oracle.com/technetwork/server-storage/san-storage/documentation/index.html

References

<NOTE:2162812.1> - FS System: Get ORA-15032, ORA-15242, ORA-15287 errors when enable HCC Compression On Flash Storage FS1
<NOTE:1530772.1> - Pillar Axiom: How to Implement Oracle Hybrid Columnar Compression on Pillar Axiom SAN Storage

Attachments

This solution has no attachment