High Temp Usage - need help to do findings

  • From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Aug 2011 17:25:08 +0530

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

Other related posts: