Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index compression on Oracle 9.2

Re: Index compression on Oracle 9.2

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Fri, 3 Feb 2006 11:26:36 +0000
Message-ID: <d6f0def50602030326j4fe157c2m9d82c24cd1b4fab9@mail.gmail.com>


Dave, Tanel,

Thank you very much for spotting the areas there the "compressed table" feature can be used.
It still looks to me usable only for specific (DHW kind) areas. Audit data is good one :)

I would like to make some testing of the feature in nearest time (influence on CPU consumption the most interesting question). I will update list on the results.

BTW: If some body have got results of that kind of testing, please do not hesitate to share them with the list ;))))

Jurijs

On 2/3/06, Tanel Põder <tanel.poder.003_at_mail.ee> wrote:
> (pressed send too fast)
>
> It depends where you're standing - a DW DBA or someone having to deal with
> lots of audit data stored over long period of time would rank table
> compression quite high. OLTP DBAs don't have any value for this feature.
>
> Tanel.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jurijs
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 03 2006 - 05:26:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US