Re: EBS (12.1.3) / HCC and SSC
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: carlos.sierra.usa@xxxxxxxxx
- Date: Wed, 7 May 2014 14:49:01 +0100
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@xxxxxxxxx>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@xxxxxxxxx>
> 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@xxxxxxxxx
> Phone: +31 20 8946342
> Mobile: +31 6 14180860
>
> On 07 May 2014, at 07:41, George Leonard - Business Connexion <
> George.Leonard@xxxxxxxxx> 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@xxxxxxxxx <george.leonard@xxxxxxxxxx>
> Web: http://www.bcx.com <george.leonard@xxxxxxxxxx>
>
> <image003.gif>
>
>
>
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
