I have table with a lot of partitions.

The pctfree is set very high for this table. I can alter the table and
reset pctfree and than move each partition to reclaim my space.

Example of what I am doing:

alter table MTAS.MTAS_RESULT pctfree 0;
alter table MTAS.MTAS_RESULT move partition RESULT_20100831 parallel 8;
....
....
...
500 partitions ...

This generates way too much redo, which I don't want.

My questions:

1) is there anyway I can check a view that will show me which DDL is
generating redo. In my example above I would expect to see this
statement.


2) If I use the nologging option, will this avoid generating ALL redo for
this statement?

alter table MTAS.MTAS_RESULT move partition RESULT_20100831 parallel 8 nologging;

I am trying to verify if this is the case by seeing what is actually written to
the redo logs if that is possible

Thanks to all who answer