Faster way of creating a unique index

[jmodic]

Originally posted by mike9
... with paralllel 4 your query will use up to 4 times the value set by sort_area_size.

I don't think so. This parameter limits the maximum size of sort area *per session*, not per process.

[mike9]

The sort_area_size parameter limits the size of a sort work area. During a sort each parallel process will have his own work area which will be used to sort the data in the memory. That means that each process will have a sort area of a maximum size defined by sort_area_size.

It's only if you work with workarea_size_policy set to true that you will have a parameter which limits the PGA size per session, this parametre is "_smm_px_max_size".