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;