Oracle Compression aginst 3 TB Tablespaces
Hi,
we are int he process of oracle compression, Approximately how long will it take for to complete 8 TB sizes of tablespaces with 32 CPU and temp space is around 500 GB.
How long it will take for oracle advanced OLTP compression
and also on which we have partional table with 2501 partition but the size of the table including partition is only 10 GB, will oracle compress these partitions & table without any issue.
and also for to compression against 1.2 TB of single partition object, what could be temp size required.how long it will take.
Will oracle Advanced OLTP compression generates more archivelogs.