Re: Doing large sort in RAM - sort workarea manipulation
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: Grzegorz Goryszewski <grzegorzof@xxxxxxxxxx>
- Date: Sun, 13 Nov 2011 08:05:13 -0800
On Sun, Nov 13, 2011 at 1:56 AM, Grzegorz Goryszewski
<grzegorzof@xxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
