Re: EBS (12.1.3) / HCC and SSC

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 7 May 2014 14:49:01 +0100
Message-ID: <CABe10sa0TVRLS_hRBHiHcn0=sK6Gj8wPY7azJCwSVCqHNQj2+g_at_mail.gmail.com>

It is notable that HCC is missing from
http://www.oracle.com/technetwork/database/features/availability/maa-ebs-exadata-197298.pdf(though advanced compression isnt).

On Wed, May 7, 2014 at 2:42 PM, Carlos Sierra <carlos.sierra.usa_at_gmail.com>wrote:

> George,
>
> Please send me contact info of the engineer that claims HCC is not
> supported by EBS, or the MOS note he is referring to. In the past I have
> heard similar claims like partitioning or custom indexes are not supported
> by EBS (both false). So I want to investigate this claim accordingly.
>
> Thanks — Carlos
>
>
>
> On May 7, 2014, at 9:01 AM, Frits Hoogland <frits.hoogland_at_gmail.com>
> wrote:
>
> Hi George.
>
> I am by no means an EBS specialist. I am aware a lot of database stuff
> needs to be done in an 'EBS way'.
> However. Essentially EBS is a client of the database (only oracle itself
> made it, instead of a 3rd party)
>
> HCC is a compression technique which requires no client SQL change to be
> used.
> So if you've got partitions with data that will not change anymore (HCC
> compression doens't like changes), there is no reason not to compress it.
> Said that, you should be aware of anything that will break when doing the
> mandatory recreation via direct path. (alter table move for example)
>
> Frits Hoogland
>
> http://fritshoogland.wordpress.com
> frits.hoogland_at_gmail.com
> Phone: +31 20 8946342
> Mobile: +31 6 14180860
>
> On 07 May 2014, at 07:41, George Leonard - Business Connexion <
> George.Leonard_at_bcx.co.za> wrote:
>
> <RSImage.jpeg>
> Hi all
>
> Ok, was a bit taken aback yesterday when an engineered informed me that
> HCC is not supported on EBS (12.1.3).
>
> I can't imagine that a Exa feature is not supported by now, nearly 6
> years after V1.
>
> Is this really so, the client have data spanning 15+ years in their line
> items tables, we want to partition the table and HCC compress OLLDDDD data.
> It was a big part of the business case.
>
> Luckily the SSC will be a consolidation platform sot he value of HCC is
> still valid for the DW and other systems.
>
> But really, Oracle not supporting HCC on EBS on Engineered systems...
> Thats like something I would expect from SAP.
>
> Please help - URGENT. (If you have a note number that tells otherwise,
> and specifies how to partition EBS would appreciate it)
>
> (ME <> EBS expert).
>
> Yours Sincerely
>
> ________________________________________
> *George Leonard*
> *Oracle Engineered System Specialist*
>
> Mobile: +27.82 655 2466
> eMail: george.leonard_at_bcx.co.za <george.leonard_at_oracle.com>
> Web: http://www.bcx.com <george.leonard_at_oracle.com>
>
> <image003.gif>
>
>
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 07 2014 - 15:49:01 CEST