Re: Faster index creation

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 14 May 2008 22:05:23 GMT
Message-ID: <482b6222$0$30638$834e42db@reader.greatnowhere.com>

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/products/bi/db/10g/pdf/ twp_general_sort_performance_10gr2_0605.pdf

Thanks to Paul Drake for warning me!

-- 
http://mgogala.freehostia.com

Received on Wed May 14 2008 - 17:05:23 CDT

This message: [ Message body ]
Next message: mccmx_at_hotmail.com: "Restore and Rename a database from RMAN backupsets"
Previous message: joel garry: "Re: Faster index creation"
In reply to: Mladen Gogala: "Re: Faster index creation"
Next in thread: Mladen Gogala: "Re: Faster index creation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message