(wrong string) – how much compression was done?
From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Thu, 13 May 2010 07:54:42 -0700 (PDT)
Message-ID: <fa75e35e-e976-4e37-a9a6-e4c1ddef2311_at_h37g2000pra.googlegroups.com>
On Apr 11, 6:17 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> 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?
Date: Thu, 13 May 2010 07:54:42 -0700 (PDT)
Message-ID: <fa75e35e-e976-4e37-a9a6-e4c1ddef2311_at_h37g2000pra.googlegroups.com>
On Apr 11, 6:17 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> 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?
Hi,
Hopefully the following link will help you:
http://www.oracle.com/technology/oramag/oracle/10-jan/o10compression_l1.html
Regards,
Sandy
Received on Thu May 13 2010 - 09:54:42 CDT