Awesome new feature for HCC

Posted by Steve Tunstall on Oracle Blogs See other posts from Oracle Blogs or by Steve Tunstall
Published on Tue, 2 Jul 2013 18:01:35 +0000 Indexed on 2013/07/02 23:12 UTC
Read the original article Hit count: 472

Filed under:

/ZFSSA

I've talked about HCC (Hybrid Columnar Compression) before. This is Oracle's built-in compression feature, free of charge in 11Gr2, that allows a CRAZY amount of compression on historical data inside an Oracle database. It only works if the database is being stored in a ZFSSA, Exadata or Axiom. You can read all about it in this whitepaper, which shows the huge value of HCC when used with the ZFSSA. http://www.oracle.com/technetwork/articles/servers-storage-admin/perf-hybrid-columnar-compression-1689701.html

Now, even better, Oracle has announced a great new feature in Oracle 12c called "Automatic Data Optimization". This allows one to setup HCC to AUTOMATICALLY compress data AS IT AGES.

So this is now ILM all built into the Oracle database. It's free for crying out loud. It just needs to be sitting on Oracle storage, such as the ZFSSA, Exadata or Axiom.

Read about ADO here: http://www.oracle.com/technetwork/database/automatic-data-optimization-wp-12c-1896120.pdf?ssSourceSiteId=ocomen

Related posts about /ZFSSA

Quotas - Using quotas on ZFSSA shares and projects and users

as seen on Oracle Blogs - Search for 'Oracle Blogs'
So you don't want your users to fill up your entire storage pool with their MP3 files, right? Good idea to make some quotas. There's some good tips and tricks here, including a helpful workflow (a script) that will allow you to set a default quota on all of the users of a share at once. Let's… >>> More
New ZFSSA code release - April 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A new version of the ZFSSA code was released over the weekend. In case you have missed a few, we are now on code 2011.1.2.1. This minor update is very important for our friends with the older SAS1 cards on the older 7x10 systems. This 2.1 minor release was made specifically for them… >>> More
Oracle ZFSSA Hybrid Storage Pool Demo

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The ZFS Hybrid Storage Pool (HSP) has been around since the ZFSSA first launched. It is one of the main contributors to the high performance we see on the Oracle ZFSSA both in benchmarks as well as many production environments. Below is a short video I made to show at a high level just… >>> More
Awesome new feature for HCC

as seen on Oracle Blogs - Search for 'Oracle Blogs'
I've talked about HCC (Hybrid Columnar Compression) before. This is Oracle's built-in compression feature, free of charge in 11Gr2, that allows a CRAZY amount of compression on historical data inside an Oracle database. It only works if the database is being stored in a ZFSSA, Exadata or Axiom. You… >>> More
Download the ZFSSA Objection Handling document (PDF)

as seen on Oracle Blogs - Search for 'Oracle Blogs'
View and download the new ZFS Storage Appliance objection handling document from the Oracle HW Technical Resource Centre here. This document aims to address the most common objections encountered when positioning the ZFS Storage Appliance disk systems in production environments. It will… >>> More

Developer IT