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

From: Harel Safra <harel.safra@xxxxxxxxx>
To: genegurevich@xxxxxxxxxxxx
Date: Tue, 26 Jan 2010 21:41:28 +0200

Just checking, you do have "degree" defined as greater than 1 on thoseindexes?


Harel Safra

On 26/01/2010 17:43, genegurevich@xxxxxxxxxxxx wrote:

Hello:

I am running this under oracle 10.2.0.3:

alter table OWNER.TABLE  modify partition P1 rebuild unusable local indexes
;

The partition has 150-200M rows and three indices. All indices as well as
the table itself are partitioned either 8 or 12 ways, but the alter table
command seems to be only running in sequential mode (and takes over 10
hours).  Is there anyway run it in parallel?

Thank you

Eugene Gurevich


Please consider the environment before printing this email.


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

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

Follow-Ups:

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

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

References:
- ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
  - From: genegurevich

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

Other related posts: