Re: Doing large sort in RAM - sort workarea manipulation
From: Greg Rahn <greg_at_structureddata.org>
Date: Sun, 13 Nov 2011 08:05:13 -0800
Message-ID: <CAGXkmiu71K01b6S=R_-m88US+a6v5vn6UQ4=ZNveVSxCUrGFmw_at_mail.gmail.com>
On Sun, Nov 13, 2011 at 1:56 AM, Grzegorz Goryszewski <grzegorzof_at_interia.pl> wrote:
> On 2011-11-13 01:24, Greg Rahn wrote:
> 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 .
Date: Sun, 13 Nov 2011 08:05:13 -0800
Message-ID: <CAGXkmiu71K01b6S=R_-m88US+a6v5vn6UQ4=ZNveVSxCUrGFmw_at_mail.gmail.com>
On Sun, Nov 13, 2011 at 1:56 AM, Grzegorz Goryszewski <grzegorzof_at_interia.pl> 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?
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 13 2011 - 10:05:13 CST