Re: OLTP compression slow update
- From: Michael Dinh <mdinh235@xxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Thu, 27 Dec 2012 10:50:35 -0800
Thanks all for the ressponse.
Still testing and will share results.
-Michael.
On Thu, Dec 27, 2012 at 4:52 AM, rjamya <rjamya@xxxxxxxxx> wrote:
> I saw this first in early 10g versions of plain vanilla compression (not
> fancy oltp etc). We were analyzing http/smtp logs collected company-wide,
> Initially we had daily partitions. since it started getting large quickly
> (we had open web at that time), I introduced partition compression, it
> worked like magic. When updates (due to occasional re-loads, corrections,
> ranking etc) to compressed partitions took long, we redesigned our
> strategy. Kept 7 days worth of parttions uncompressed, and everything older
> was compressed. That worked out well in the end. I guess the update issue
> on compressed data still needs work then :)
> Raj
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
