Home » RDBMS Server » Server Administration » Hybrid Columnar Compression: useful bug
Hybrid Columnar Compression: useful bug [message #541607] Wed, 01 February 2012 05:27
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
As I'm sure you all know, HCC is possible only if your storage is Exadata or (since 11.2.0.3) ZFS or Pillar. This is really annoying if you are trying to demos when you don't have access to Exadata, ZFS, or Pillar all the time.
I found this article Bug 13362079 - HCC compression should not be allowed on dNFS with non ZFS or Pillar [ID 13362079.8] which says that if you use Direct NFS then HCC does work: "With dNFS enabled, creating an HCC compressed table succeeds even if the storage being used is not ZFS or Pillar." The bug gets "fixed" in 11.2.0.3.1, but until then it would be really useful.
So I set up an NFS share, enabled dNFS, crated a tablespace on the share, but HCC doesn't work:
SQL> create table comphcc(c1 varchar2(10)) tablespace forhcc compress for archive high;
create table comphcc(c1 varchar2(10)) tablespace forhcc compress for archive high
*
ERROR at line 1:
ORA-64307: hybrid columnar compression is not supported for tablespaces on this
storage type


SQL> select * from v$dnfs_servers;

        ID
----------
SVRNAME
--------------------------------------------------------------------------------
DIRNAME
--------------------------------------------------------------------------------
   MNTPORT    NFSPORT      WTMAX      RTMAX
---------- ---------- ---------- ----------
         1
192.168.56.101
/nfs/orcldata
     43280       2049          0          0

I wondered if anyone had tried this? I can't raise a TAR complaining that a bug doesn't work! Basically, what I want is a way to get HCC working in a simulated environment.
Previous Topic: Limitations of Database links
Next Topic: USERS tablespace
Goto Forum:
  


Current Time: Thu Mar 28 06:12:10 CDT 2024