"zeb" <thierry.constant1.nospam_at_free.fr> wrote in message news:<3ec747cb$0$17283$626a54ce_at_news.free.fr>...
> Hi,
>
> Is there a way to estimate the sort_area_size for the creation of index for
> a big table ?
>
> Thanks in advance
If you are using 9i, look into PGA_AGGREGATE_TARGET and
WORKAREA_SIZE_POLICY instead trying to manually tune SORT_AREA_SIZE,
HASH_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, and CREATE_BITMAP_AREA_SIZE.
Set WORKAREA_SIZE_POLICY to auto, size PGA_AGGREGATE_TARGET properly
and let ORACLE worry about PGA management.
Received on Sun May 18 2003 - 12:00:32 CDT
