(wrong string) – how much compression was done?

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sun, 11 Apr 2010 19:57:34 -0700 (PDT)
Message-ID: <50541a2a-b101-4c2a-8447-3439a8580e20_at_x12g2000yqx.googlegroups.com>



On Apr 11, 7:34 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> On Apr 10, 9:17 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
> snip
>
> > I am using Oracle 11g (11.1) on HP UNIX 11i. I have set some tables
> > using
> > Alter table mytable compress for all operations;
>
> > Lots of data is being inserted into this table. I want to find how
> > much disk space was reduced because of compression. I cannot take all
> > this data and create another table without compression and then try to
> > compare the disk space for two. Does Oracle provide any tools to find
> > how much compression was done?
>
> Did you read the doc?

Yes,, I have read the docs, did not find anything. Received on Sun Apr 11 2010 - 21:57:34 CDT

Original text of this message