Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Running create index with parallel on a partition table

OracleappsdbaNov 3 2010 — edited Nov 3 2010

Hi All,

Database version - 11.2.0.1

We have a partition table ( have 3 partition ) with no parallel and 4 local indexes with no parallel.

Changed the parallel degree of the tale to 6 and creating a 5th index on that table with parallel 6 option in create index command.

Database is taking only 3 parallel process [ each for each partition ] and the bigger partition tablescan is running for longer time.

Please advice if there are any way to run this in parallel 6 or greater to complete the creation process quickly.

Thanks & Regards,
Rakesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2010

Added on Nov 3 2010

#general-database-discussions

3 comments

1,178 views