High Temp Usage - need help to do findings
From: Shastry(DBA) <"Shastry>
Date: Thu, 25 Aug 2011 17:25:08 +0530
Message-ID: <CAFQkUXRq2uVa_PcWwSNp9hZrm6tBeiE6GEGkx3oSKkVLBaM4QA_at_mail.gmail.com>
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?
Date: Thu, 25 Aug 2011 17:25:08 +0530
Message-ID: <CAFQkUXRq2uVa_PcWwSNp9hZrm6tBeiE6GEGkx3oSKkVLBaM4QA_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 25 2011 - 06:55:08 CDT