-
moving partitions and generating redo
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|