Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
Date: Wed, 27 Jan 2010 08:49:35 -0600
Another potential concern is that if one is doing parallel DDL on a 10gR2 RAC system with parallel automatic tuning, the instance on which you issue the DDL command is not guaranteed to be the instance on which the parallel slaves execute. I was quite surprised when I didn't find the parallel query slaves for a CREATE INDEX PARALLEL statement in v$session, but in gv$session.
On Wed, Jan 27, 2010 at 4:34 AM, Martin Bach
> Oh la! You might want to be careful with step 2 in case you have a dataguard
> physical standby.
> On 01/26/2010 09:27 PM, Taral Desai wrote:
>> I think this would be a way to do
>> 2. ALTER INDEX owner.indexname rebuild REBUILD PARTITION <partition
>> name> NOLOGGING PARALLEL 8;
> -> The nologging option will certainly cause you trouble, see metalink note
> "the gains and pains of nologging operations" first.
> Martin Bach
> OCM 10g
-- Adam Musch ahmusch_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 27 2010 - 08:49:35 CST