Database DataWarehousing (MOSC)

MOSC Banner

During compression activity Huge no of Temp segments are used

edited Sep 2, 2014 11:39AM in Database DataWarehousing (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center