Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id D1C7F1961199 for ; Mon, 8 Aug 2016 09:57:26 +0200 (CEST) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Mon, 8 Aug 2016 09:57:26 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B76CF2664E; Mon, 8 Aug 2016 03:57:24 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id EA-icA_9_-j5; Mon, 8 Aug 2016 03:57:24 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E29FF26652; Mon, 8 Aug 2016 03:57:11 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 08 Aug 2016 03:55:50 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1278F264A4 for ; Mon, 8 Aug 2016 03:55:50 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id wzUncoQ7fxR1 for ; Mon, 8 Aug 2016 03:55:50 -0400 (EDT) Received: from mail-wm0-f42.google.com (mail-wm0-f42.google.com [74.125.82.42]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id B7A5B26408 for ; Mon, 8 Aug 2016 03:55:49 -0400 (EDT) Received: by mail-wm0-f42.google.com with SMTP id o80so120433394wme.1 for ; Mon, 08 Aug 2016 00:55:49 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=jgc42J5og4UETnFuqn6Xf7mKN6d0VZjPX/+8ec0s7Ms=; b=aKBNfHEh0Pd7kPYP0J3b+vmlXlaEFTHOpF6+vKihneo9nnh8TLTt7m4MqY5Xc4w5n8 jg7+QXVnSApKJbD4CoWbswHvmrSqYcgRz2gvbJJmGKvmhGxNZhSG8LjzgoKwbfze8MzN uPySrv6hYLWFDcvqtoYTix0MVmTVnbUvrRU0s5eh9PJ/MFwwwEWfVrc+rD2mNMeCRRLm BBtuj6iSdIsXiwY+uxhr1I1oLTQ4LlLscgvo2D0Fx6MSv9foIzF+RQp6SlxBEH8mreBf 2jKbLBqJ5rkeHff4akvWJM+Z2d95emGM7t364REQ950o9Cs40lTWsHxsjAvOIqewjl4J U+Ww== X-Gm-Message-State: AEkooutc+PRlO0eHog9+tMBmSsozM+zjUHyRzCiRxyXfPx/xPi0/SqPEl80SztnIbFeQSlvuAM59rLXveYWA1Q== X-Received: by 10.194.184.39 with SMTP id er7mr79631646wjc.159.1470642948440; Mon, 08 Aug 2016 00:55:48 -0700 (PDT) MIME-Version: 1.0 Received: by 10.194.28.7 with HTTP; Mon, 8 Aug 2016 00:55:27 -0700 (PDT) In-Reply-To: <72fc74f6bf51cea9a2328c36f3e532ca.squirrel@lady.zephyrus.com> References: <527c8874d4352cd71b49b6298604683b.squirrel@lady.zephyrus.com> <72fc74f6bf51cea9a2328c36f3e532ca.squirrel@lady.zephyrus.com> From: Martin Berger Date: Mon, 8 Aug 2016 09:55:27 +0200 Message-ID: Subject: Re: HCC on ZFS To: kmoore@zephyrus.com Cc: mark@bobak.net, Jonathan Lewis , "oracle-l@freelists.org" Content-Type: multipart/alternative; boundary=047d7ba97a10888dd905398abe62 X-archive-position: 65889 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: martin.a.berger@gmail.com Precedence: normal Reply-To: martin.a.berger@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --047d7ba97a10888dd905398abe62 Content-Type: text/plain; charset=UTF-8 Keith, if you want to learn something about the mechanics behind, maybe this blogpost will help (for educational purpose only, of course). http://techblogsearch.com/a/hcc-on-non-exadata-how-oracle-is-detecting-storage-type.html Martin 2016-08-03 23:43 GMT+02:00 Keith Moore : > I was thinking of it from the other end. Hack SNMP to return the type of > storage expected but would have to research how to do that. > > But like you say, not something you could do to your production (or even > licensed) databases. > > Keith > > > Also, as I recall, someone (Randolf Geist, If I recall correctly) did a > > blog on how to hack your DB so that the function that checks the storage > > type always returns success, and was able to get HCC to work on any > > arbitrary storage. Obviously, this is not something you can do to your > > production DB, but would be a fun experiment to do on a throwaway test or > > sandbox DB. > > > > -Mark > > > > On Wed, Aug 3, 2016 at 1:53 PM, Jonathan Lewis < > jonathan@jlcomp.demon.co.uk> > > wrote: > > > >> > >> That is correct - it's purely a software choice. > >> In fact if you have a simple Linux system you can use the > dbms_compression > >> package to create HCC compressed data for calculating possible > compression > >> factors - though you can't access the data after it's been created: > >> http://jonathanlewis.wordpress.com/2011/10/04/hcc/ > >> > >> Regards > >> Jonathan Lewis > >> http://jonathanlewis.wordpress.com > >> @jloracle > >> > >> ________________________________________ > >> From: oracle-l-bounce@freelists.org [oracle-l-bounce@freelists.org] on > >> behalf of Keith Moore [kmoore@zephyrus.com] > >> Sent: 03 August 2016 18:37 > >> To: oracle-l@freelists.org > >> Subject: HCC on ZFS > >> > >> We had an issue with a new Exadata/ZFS environment where a clone > database > >> on > >> ZFS storage would return ORA-64307: Exadata Hybrid Columnar Compression > is > >> not > >> supported for tablespaces on this storage type. > >> > >> That was an issue with the SNMP service on the ZFS not starting properly > >> and > >> has now been resolved. > >> > >> Based on that can someone confirm the following that seems to me to be > >> true: > >> 1. An Oracle database uses SNMP to verify the storage is either Exadata, > >> ZFS > >> or Pillar. > >> > >> 2. There is no technical reason HCC could not work on any storage but > for > >> marketing or other reasons, Oracle has decided to restrict it to only > these > >> platforms. > >> > >> Keith Moore > >> Senior Oracle DBA - ADT Security > >> > --047d7ba97a10888dd905398abe62 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Keith,=C2=A0

if you want to learn somet= hing about the mechanics behind, maybe this blogpost will help (for educati= onal purpose only, of course).

Martin

2016-08-03 23:43 GMT+02:00 Keith Mo= ore <kmoore@zephyrus.com>:
I was thinking of it from the other end. Hack SNMP to return the type of=
storage expected but would have to research how to do that.

But like you say, not something you could do to your production (or even licensed) databases.

Keith

> Also, as I recall, someone (Randolf Geist, If I recall correctly) did = a
> blog on how to hack your DB so that the function that checks the stora= ge
> type always returns success, and was able to get HCC to work on any > arbitrary storage.=C2=A0 Obviously, this is not something you can do t= o your
> production DB, but would be a fun experiment to do on a throwaway test= or
> sandbox DB.
>
> -Mark
>
> On Wed, Aug 3, 2016 at 1:53 PM, Jonathan Lewis <jonathan@jlcomp.demon.co.uk>
> wrote:
>
>>
>> That is correct - it's purely a software choice.
>> In fact if you have a simple Linux system you can use the dbms_com= pression
>> package to create HCC compressed data for calculating possible com= pression
>> factors - though you can't access the data after it's been= created:
>> http://jonathanlewis.wordpress.com/2= 011/10/04/hcc/
>>
>> Regards
>> Jonathan Lewis
>> http://jonathanlewis.wordpress.com
>> @jloracle
>>
>> ________________________________________
>> From: oracle-l-bo= unce@freelists.org [or= acle-l-bounce@freelists.org] on
>> behalf of Keith Moore [kmoo= re@zephyrus.com]
>> Sent: 03 August 2016 18:37
>> To: oracle-l@freelists.o= rg
>> Subject: HCC on ZFS
>>
>> We had an issue with a new Exadata/ZFS environment where a clone d= atabase
>> on
>> ZFS storage would return ORA-64307: Exadata Hybrid Columnar Compre= ssion is
>> not
>> supported for tablespaces on this storage type.
>>
>> That was an issue with the SNMP service on the ZFS not starting pr= operly
>> and
>> has now been resolved.
>>
>> Based on that can someone confirm the following that seems to me t= o be
>> true:
>> 1. An Oracle database uses SNMP to verify the storage is either Ex= adata,
>> ZFS
>> or Pillar.
>>
>> 2. There is no technical reason HCC could not work on any storage = but for
>> marketing or other reasons, Oracle has decided to restrict it to o= nly these
>> platforms.
>>
>> Keith Moore
>> Senior Oracle DBA - ADT Security
>>
--047d7ba97a10888dd905398abe62-- -- http://www.freelists.org/webpage/oracle-l