RE: EBS (12.1.3) / HCC and SSC
Date: Thu, 8 May 2014 09:14:04 -0400
Message-ID: <05a801cf6abf$6471ef80$2d55ce80$_at_rsiz.com>
Once again, it is NOT that HCC does NOT work with EBS.
In the typical installation it is not the most performant option because of the texture of updates to the data. In larger installations with a lot of static history that might change.
On the other hand, other types of Oracle compression have yielded performance improvements for EBS because the relative increased CPU cost for repetitive compression and unloading data blocks is more than offset by reduced CPU cost of data block i/o due to reading fewer blocks. That has been shown to be in the sweet spot of both less total CPU and less total i/o for EBS and resultant lower elapsed time for users. The only question then is whether those savings are worth the extra license cost for advanced compression if you do not already have it. If it saves you from adding more CPUs to a server license that is likely a win. Regular compression is also worth testing on a per implementation basis.
I recommend the Steven Chan blog for reading on this topic
<http://blogs.oracle.com/stevenchan> Oracle E-Business Suite Technology Blog
Worth repeating: HCC works with EBS. Something else usually works even better. (See Mike's point, below, too.)
mwf
From: George Leonard - Business Connexion [mailto:George.Leonard_at_bcx.co.za]
Sent: Thursday, May 08, 2014 12:12 AM
To: Michael Brown
Cc: Mark Farnham; niall.litchfield_at_gmail.com; ORACLE-L; Frits Hoogland;
jpiwowar_at_gmail.com
Subject: Re: EBS (12.1.3) / HCC and SSC
<snip>
Hi guys
I'm still amazed though, Oracle's Major push for Engineered systems, LJE's major push for using EHCC on Exa (it's one of the hot features of ED), with the potential compression numbers repeated often, EBS major product/revenue source.
Making me think this would have been the first combination they would make work, targeting any all EBS clients, Oracle's one GSI, I know they use HCC there, well I remember hearing they do...
Lets see, I'm doing some more digging.
<snip>
I would also expect undoing HCC to be support's first plan if they know HCC is being used and it is a performance related SR.
-- Michael Brown dba_at_michael-brown.org http://blog.michael-brown.org <http://blog.michael-brown.org/> On May 7, 2014, at 6:06 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote: That is correct. You'll want to be sure the exact patch level of the Exadata box you are using is on the EBS certification matrix for the release and patch level of EBS you are using. That makes you certified and eligible for support if the appropriate contract is paid up. If your HCC usage triggered a bug in HCC, I suppose undoing the HCC might be the recommended fix. But without a bug, the EBS application should not be able to tell the difference, and it would be a bug if it could. But you're right that it might be an HCC bug. In fact if the EBS applications can tell the difference I think that defines it as an HCC bug. Then the question would be whether or not to hold your breath until a patch was made to the hypothetical HCC bug. I'd recommend against any such breath holding. AND they do not recommend it for performance reasons due to their testing. In the case where the OP was going to do some sort of time based partitioning and HCC only the old stuff, it seems highly unlikely there would be a problem. Conversely it would probably be brain dead to HCC current invoices on and do a check run. mwf From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Wednesday, May 07, 2014 4:58 PM To: Mark W. Farnham Cc: ORACLE-L; Frits Hoogland; George.Leonard_at_bcx.co.za; jpiwowar_at_gmail.com Subject: RE: EBS (12.1.3) / HCC and SSC Right but EBS at least used to be really grotty about 'support' vs certified. Things may have changed but back in the 11.5.10 time frames I'd expect any support ticket to end with can you reproduce on a system without HCC if the diagnosis dumps showed HCC in use. Good luck with that. On 7 May 2014 17:44, "Mark W. Farnham" < <mailto:mwf_at_rsiz.com> mwf_at_rsiz.com> wrote: Frits is basically correct, as confirmed by ATG below in response to my request for clarification: Am I wrong that the applications could not really know whether the physical storage is using HCC by the time it accesses the data? I wonder whether this is failing to understand the difference between "your support does not include Oracle evaluating and setting up HCC for your particular system implementation and if you screw that up backing it out is your problem" and "if you use HCC on any part of an EBS database your installation is unsupported" and the huge range of possibilities in between. Mark, Thanks for the email. You're not wrong, an EBS instance would not know if HCC is in use. To clarify the recommendation: The Oracle E-Business Suite Performance Team does not currently recommend HCC for EBS. Our testing has shown degradation in performance with HCC and EBS (an OLTP system with high-volume tables). Thanks. ~ep Elke Phelps | Product Management | <tel:303.661.2475> 303.661.2475 |Received on Thu May 08 2014 - 15:14:04 CEST
<mailto:kenneth.baxter_at_oracle.com> elke.phelps_at_oracle.com
Oracle E-Business Applications Technology Group ORACLE | 600 Oracle Parkway | Redwood Shores, CA 94065 <http://blogs.oracle.com/stevenchan> Oracle E-Business Suite Technology Blog <snip> 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).<snip> -- http://www.freelists.org/webpage/oracle-l