Re: Doing large sort in RAM - sort workarea manipulation

From: Greg Rahn <>
Date: Sun, 13 Nov 2011 08:05:13 -0800
Message-ID: <>

On Sun, Nov 13, 2011 at 1:56 AM, Grzegorz Goryszewski <> wrote:
> On 2011-11-13 01:24, Greg Rahn wrote:
>> Can you elaborate on the specific use case you are trying to address
>> for your workload (what it is and why it's required)?

> Sure, basically I need to provide Informatica software with presorted data
> and because Oracle is limiting RAM used for sorts artificially I'm
> looking for some workarounds .

Sure, but how much data? Is your test case representative of what is required with Informatica -- e.g. Do you just need a list of keys, or do you need an entire table sorted by key?

Greg Rahn
Received on Sun Nov 13 2011 - 10:05:13 CST

Original text of this message