During compression activity Huge no of Temp segments are used
Hi ,
we are performing compression activity for a partition table which is havinv size is 183 GB and its associated local partition index is aroung 14.5 GB,
But while performing oracle advanced compression activity over the mentioned size segment. we are facing issue on temp segment scarcity, which was started using more than 55 GB, where we
don't have much space on OS level as well.
since we too face the same issue for one partition table on which we continously provided more GB around 120 GB of spaces to get success for our compression activity, But we have quite few other
very big partition table it was not used more temp space, it was using only 10 to 15 GB only also completed the compression activity successfully.