Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 27 Jan 2015 09:13:32 -0600
Message-ID: <CAP79kiSptgwRzjLkPgtDnaCh6WX2Ov8e+uBW-070O61Whvt8Ag_at_mail.gmail.com>



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_at_psbank.ru> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 27 2015 - 16:13:32 CET

Original text of this message