Re: Temporary space needed to create a constraint

Hi,
I did another test and found that by setting parallel on the index,
the constraint build will use parallel slaves. So my next try is going
to be to set a 1GB sort_area_size and then try with 4 parallel slaves,
I am hoping that this will result in more sorting being done in memory
and the temp space only used for a merge run.

Still cannot work why so much temp space gets used up.

Regards
Pete
--
http://www.freelists.org/webpage/oracle-l

Other related posts: