(wrong string) – how much compression was done?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 11 Apr 2010 16:34:03 -0700 (PDT)
Message-ID: <136cfed7-a927-4ab5-9f43-8dedf3506616_at_g30g2000yqc.googlegroups.com>
On Apr 10, 9:17 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
Date: Sun, 11 Apr 2010 16:34:03 -0700 (PDT)
Message-ID: <136cfed7-a927-4ab5-9f43-8dedf3506616_at_g30g2000yqc.googlegroups.com>
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? Received on Sun Apr 11 2010 - 18:34:03 CDT