Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?
- From: Sidney Chen <huanshengchen@xxxxxxxxx>
- To: dmarc-noreply@xxxxxxxxxxxxx
- Date: Wed, 28 Jan 2015 16:25:51 +0800
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@xxxxxxxxxxxxx>
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
Other related posts:
