Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
- From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- To: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
- Date: Tue, 27 Jan 2015 09:13:32 -0600
Interesting idea. I had forgotten about extended statistics. Let me check
into that.
Good catch!
Chris
On Tue, Jan 27, 2015 at 9:12 AM, Sayan Sergeevich Malakshinov <
malakshinovss@xxxxxxxxx> wrote:
> > 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
Other related posts:
