Prev: EssBase Architect with OBIEE - Chicago,IL
Next: expdp is painfully slow
From: sandeep pande on 13 May 2010 10:54
On Apr 11, 6:17 am, zigzagdna <zigzag...(a)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
 | 
Pages: 1
Prev: EssBase Architect with OBIEE - Chicago,IL
Next: expdp is painfully slow