Re: Temporary space needed to create a constraint
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 10 Jul 2012 22:01:18 +0100
Message-ID: <CAPMSPxMtVk2c+D3o_yQY1uXMbbKEJ+u8Uj8g3ByTUiz2Z3OO0g_at_mail.gmail.com>
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.
Date: Tue, 10 Jul 2012 22:01:18 +0100
Message-ID: <CAPMSPxMtVk2c+D3o_yQY1uXMbbKEJ+u8Uj8g3ByTUiz2Z3OO0g_at_mail.gmail.com>
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-lReceived on Tue Jul 10 2012 - 16:01:18 CDT