Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel

From: Adam Musch <ahmusch_at_gmail.com>
Date: Wed, 27 Jan 2010 08:49:35 -0600
Message-ID: <516d05a1001270649x7c190cf5n2abcf0e5f0ad602b_at_mail.gmail.com>

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 <development_at_the-playground.de> wrote:
> 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.
>
> Regards,
>
> Martin
> --
> Martin Bach
> OCM 10g
> http://martincarstenbach.wordpress.com
> http://www.linkedin.com/in/martincarstenbach
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Adam Musch
ahmusch_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 27 2010 - 08:49:35 CST