From: sandeep pande on
On Apr 11, 6:17 am, zigzagdna <zigzag...(a)> 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?


Hopefully the following link will help you: