Re: EBS (12.1.3) / HCC and SSC
- From: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
- To: frits.hoogland@xxxxxxxxx
- Date: Wed, 7 May 2014 09:42:21 -0400
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
>> Web: http://www.bcx.com
>>
>> <image003.gif>
>>
>>
>>
>
Other related posts:
