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

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 28 Jan 2015 16:25:51 +0800
Message-ID: <CAM_ddu-+ATb0Xmu=WJ5Rxg1WpXdRNDxseQHsxP8q4mM47-uUWw_at_mail.gmail.com>



Have you tried range-hash partition
on COWS_TCUE_STS_SCHEDULE/COWS_PURPLE_PART to use partition wise join?

On Wed, Jan 28, 2015 at 9:20 AM, Mladen Gogala <dmarc-noreply_at_freelists.org> wrote:

> On 01/27/2015 01:40 PM, Chris Taylor wrote:
>
> Wow, thanks Mark!
>
> Indeed, the GROUP BY was left over from trying to run this for multiple
> periods so I need to examine that - great catch.
>
> Spiny Starfish - not familiar with this but I assume it's online
> somewhere? If so (and it's free) I'll pull it up/down and read over it.
>
>
> Spiny Starfish is Mark's presentation from OOW, available for download
> here:
>
>
> https://oracleus.activeevents.com/connect/sessionDetail.ww?SESSION_ID=6472&tclass=popup
>
> If you cannot download it, contact me directly, I have it on my computer
> and will gladly forward it to you.
> And it's not free, it will cost you one virtual beer.
>
> --
> Mladen Gogala
> Oracle DBAhttp://mgogala.freehostia.com
>
>

-- 
Regards
Sidney Chen

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 28 2015 - 09:25:51 CET

Original text of this message