Re: Estimating HCC ratios
From: RajeevGM <rprabha01_at_gmail.com>
Date: Wed, 28 Jun 2017 08:10:07 -0400
Message-Id: <1C7F79EB-0E7F-4E11-AABA-90754592E07A_at_gmail.com>
Date: Wed, 28 Jun 2017 08:10:07 -0400
Message-Id: <1C7F79EB-0E7F-4E11-AABA-90754592E07A_at_gmail.com>
Hi,
> On Jun 28, 2017, at 7:45 AM, Pantheon Systems <pantheon.oracle_at_gmail.com> wrote:
>
> Let me clarify
>
> If I hv HCC enabled right now, how do I tell how effective it is
>
> I.e : How well it's compressing the data to a similar set of data ( the same database ) that doesn't hv HCC-enabled
>
>
>
>
>
>> On Jun 27, 2017, at 21:06, Andy Klock <andy_at_oracledepot.com> wrote: >> >>> On Tue, Jun 27, 2017 at 7:50 PM, Pantheon Systems <pantheon.oracle_at_gmail.com> wrote: >>> Folks >>> >>> Is there a way to estimate HCC compression ratios? >>> >>> I.e.. To what extent HCC is employed in the database ? >>> >>> Or what percentage of tables are HCC compressed & their ratios & whether it is archive high / low and so on >> >> I'm not sure I exactly understand your question. If you don't have a means to test actual compression, you can estimate compression ratios by sampling your data with DBMS_COMPRESSION. How you employ it and what percentage of the tables use HCC in your database is really up to what your needs are. If your tables are bulk loaded and only SELECTed from then HCC may be great. If they are heavily DMLed then probably not so great. >> >> Andy K
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 28 2017 - 14:10:07 CEST