Prev: Avoiding refresh in MV replication
Next: importing DBMS_SCHEDULER jobs - date formatting problem...
From: zigzagdna on 10 Apr 2010 21:17
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?


From: John Hurley on 11 Apr 2010 19:34
On Apr 10, 9:17 pm, zigzagdna <zigzag...(a)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?
From: zigzagdna on 11 Apr 2010 22:57
On Apr 11, 7:34 pm, John Hurley <hurleyjo...(a)yahoo.com> wrote:
> On Apr 10, 9:17 pm, zigzagdna <zigzag...(a)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?

Yes,, I have read the docs, did not find anything.
 | 
Pages: 1
Prev: Avoiding refresh in MV replication
Next: importing DBMS_SCHEDULER jobs - date formatting problem...