On Wed, 14 May 2008 20:46:07 +0000, Mladen Gogala wrote:

> This no longer applies to 10.2 and later. There is a new sort algorithm
> in 10.2, specifically rewritten to make use of larger memories,
> available through PGA_AGGREGATE_TARGET. There is a paper about this
> here: http://tinyurl.com/5hc3l

I humbly apologize for being sloppy. The link is:
http://tinyurl.com/5hc3le
In case this fails, the link is:
http://www.oracle.com/technology/pro...bi/db/10g/pdf/
twp_general_sort_performance_10gr2_0605.pdf

Thanks to Paul Drake for warning me!



--
http://mgogala.freehostia.com