Skip to Main Content

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!

create an index with parallel?

Peter KDec 31 2009 — edited Jan 4 2010
I am attempting to create an index with the parallel option. I'm expecting to see several parallel processes in the plan, but none appear. Could anyone explain why ?

I think I have set all the session settings correctly, although I would appreciate some verifcation on this!
alter session force parallel query;

alter system set parallel_max_servers = 24;

alter table FDM.WH_BOOKS_D parallel;

create index wbks_uk2 on wh_books_d (book_business_date, book_code, book_id)
  tablespace fdm_index
  parallel
  nologging
  local;
The plan that appears is as follows:
Plan 
CREATE INDEX STATEMENT FIRST_ROWS Cost: 18,294 Bytes: 892,102,400 Cardinality: 31,860,800  
  6 PX COORDINATOR  
    5 PX SEND QC (RANDOM) PARALLEL_TO_SERIAL SYS.:TQ10000 :Q1000 Bytes: 892,102,400 Cardinality: 31,860,800  
      4 PX PARTITION RANGE ALL PARALLEL_COMBINED_WITH_CHILD :Q1000 Bytes: 892,102,400 Cardinality: 31,860,800 Partition #: 3 Partitions accessed #1 - #2440 
        3 INDEX BUILD NON UNIQUE (LOCAL) PARALLEL_COMBINED_WITH_PARENT WBKS_UK2 :Q1000 Partition #: 3 Partitions accessed #1 - #2440 
          2 SORT CREATE INDEX PARALLEL_COMBINED_WITH_PARENT :Q1000 Bytes: 892,102,400 Cardinality: 31,860,800  
            1 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT FDM.WH_BOOKS_D :Q1000 Cost: 17,976 Bytes: 892,102,400 Cardinality: 31,860,800 Partition #: 3 Partitions accessed #1 - #2440 
 
P;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2010
Added on Dec 31 2009
6 comments
3,359 views