Explain plan? Can you provide one with temp usage estimates, ( if you aren't sure how, feel free to email me, I'll be glad to help...) Kellyn Pot'Vin Sr Database Adminstrator and Developer Dbakevlar.com Sent from T-Mobile G2 with Google "Shastry(DBA)" <shastry17@xxxxxxxxx> wrote: >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