| Hybrid Columnar Compression: useful bug [message #541607] |
Wed, 01 February 2012 05:27 |
John Watson
Messages: 8960
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
