Hi All, I am having the below query running on one of my prod instance and consuming 8GB of temp space and failing sometimes. Would you please help and suggest some approach to find why its consuming so much of TEMP usage? CREATE TABLE /*+APPEND PARALLEL(8, 4) */ COOKINGS_W_264_c TABLESPACE taxdata PARALLEL (DEGREE 8 INSTANCES 4) COMPRESS FOR ALL OPERATIONS AS SELECT /*+ APPEND PARALLEL(v, 8, 4)*/ v.* FROM vw_COOKINGS_W v WHER E comparison_basis = 'Current' AND v.fiscal_month_key = 264 Thanks, Ann