FND_LOBS DBMS_REDEFINITION.START_REDEF_TABLE - SLOW

To All:

11.2.0.4 - rdbms

6.5 RHEL - 64bit

Single server with 5 x 4 cpu cores

Synology flash drives - Over 1tb available for our disk farm.

Mount point is on sdb  /d01

Currently performing a redef of our tablespace APPS_TS_MEDIA and implementing advanced compression, securefiles, high dedupe in order to compress and consolidate the tablespace.

Export/Import is not going to be used.  We are using dbms_redef for the single table FND_LOBS and its associated huge lob_segment located within APPS_TS_MEDIA.

Issued the following to prep the migration:

Set init parameters:

standard 8k blocks

*.db_securefile=ALWAYS