Re: archive database; --compress it but still readonly access to limited user;

From: Zhu,Chao <>
Date: Thu, 6 Nov 2008 21:59:35 +0800
Message-ID: <>

Quick update;
for the long columns, we are evaluating using utl_compress to convert to blob and do compress and update the code to handle blob instead of reading from long. code update should be mininum as only few customer service app reading it.

On Fri, Oct 31, 2008 at 3:57 PM, Zhu,Chao <> wrote:

> hi, friends,
> We have a few database which stores archived data, it become huge in
> the past few years, as big as 100TB+.
> We have used compress table to reduce size for non-long/long raw tables
> and it helps reduce size to 1/3-1/6 with proper sort during CTAS. But 50%+
> of the data are actually with LONG column. Two questions;
> 1. With 11g secure lob compression, anyone has experience with that? We can
> consider upgrade to 11g if that really helps.
> 2. Any solution outside of database? Like at Host/SAN layer... We
> considered ZFS (we are on Sun) and SAN team declined the idea.
> Any comment/experience is welcome. Thanks.
> --
> Regards
> Zhu Chao

Zhu Chao

Received on Thu Nov 06 2008 - 07:59:35 CST

Original text of this message