Good Afternoon Tom,

I'm going to develop a little SQL Tool for maintenance of compress tables and indexes for our DWH Schema, our clients have Oracle EE (11.2 and 12.2), my "big" doubt is use or not use parallel execution because i see that using parallel execution increase the number of extents (as Oracle doc says); in your opinion which is the best way?
this is my SQL output:


alter table owner.table_name enable row movement
/
alter table owner.table_name move tablespace tablespace_name compress for oltp
(noparallel or parallel n?)
/
alter table owner.table_name deallocate unused
/
alter table owner.table_name disable row movement
/
alter index owner.index_name rebuild tablespace tablespace_name compress
(noparallel or parallel n?)
/
alter index owner.index_name shrink space compact
/
alter index owner.index_name deallocate unused
/


then usually i get gather_schema_stats with ad hoc preferences.

Thanks in advance for your attention,
and sorry for my english.

Andrea.