Re: Temporary space needed to create a constraint
- From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Jul 2012 22:01:18 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
