(wrong string) – how much compression was done?
From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sat, 10 Apr 2010 18:17:54 -0700 (PDT)
Message-ID: <638934e9-8d62-40ed-9fd2-e4f74adf6898_at_u34g2000yqu.googlegroups.com>
I am using Oracle 11g (11.1) on HP UNIX 11i. I have set some tables using
Alter table mytable compress for all operations;
Date: Sat, 10 Apr 2010 18:17:54 -0700 (PDT)
Message-ID: <638934e9-8d62-40ed-9fd2-e4f74adf6898_at_u34g2000yqu.googlegroups.com>
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? Received on Sat Apr 10 2010 - 20:17:54 CDT