Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Tue, 27 Jan 2015 18:12:45 +0300
Message-ID: <OF0C88F2F0.5AAF6D45-ON43257DDA.00530B17-43257DDA.00538F33_at_psbank.ru>
> Also, it completed successfully for period 20142 but the explain
> plan for that one said it would need 573 TB of TEMP space so now I
> realize I have zero way to "guess" how much temp space it really
> needs but that 150 GB isn't enough.
>
> The stats are accurate for 100% estimation so I'm not sure why the
> estimate on the temp space is so high.
Date: Tue, 27 Jan 2015 18:12:45 +0300
Message-ID: <OF0C88F2F0.5AAF6D45-ON43257DDA.00530B17-43257DDA.00538F33_at_psbank.ru>
> Also, it completed successfully for period 20142 but the explain
> plan for that one said it would need 573 TB of TEMP space so now I
> realize I have zero way to "guess" how much temp space it really
> needs but that 150 GB isn't enough.
>
> The stats are accurate for 100% estimation so I'm not sure why the
> estimate on the temp space is so high.
How different are values of "A-Rows" from "E-rows"?
It seems that you have to gather extended statistics on
(STS_PROVIDER,STS_PROGRAM_NO) and on
(STS_PERF_PERIOD,STS_DPS_TYPE,STG_GROUP_NO,STG_GROUP_SEQ_NO) column sets.
-- Best regards, Sayan Malakshinov http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 27 2015 - 16:12:45 CET