Re: Doing large sort in RAM - sort workarea manipulation

From: Greg Rahn <>
Date: Sat, 12 Nov 2011 07:45:35 -0800
Message-ID: <>

If you need to allocate more pga... then parallel execution will probably be your friend. PX lets you address more memory for the sort by scaling it out. At that point you just need to have a large enough pga_aggregate_target and large enough DOP to keep the operation from spilling.

On Sat, Nov 12, 2011 at 2:36 AM, Grzegorz Goryszewski <> wrote:
> Example:
> If you like to use a sort area size of 2GB for a special operation (e.g
> for the creating of an index on a large table) you could set the values
> as follows:
> "_PGA_MAX_SIZE" = 2G
> "_SMM_MAX_SIZE" = 2097152
> but what If I need more , I've found some claims that maximum size of
> sort area is hardcoded to 4GB and cant be
> exceeded .

Greg Rahn
Received on Sat Nov 12 2011 - 09:45:35 CST

Original text of this message