APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 23-Nov-2016***
GOAL
Indexes seem always created with parallel degree 1 during import as seen from a sqlfile.
The sql file shows content like:
CREATE INDEX "AP"."AP_INVOICE_DISTRIBUTIONS_N2" ON
"AP"."AP_INVOICE_DISTRIBUTION
S_ALL" ("POSTED_FLAG")
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE
DE
FAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL 1 ;
ALTER INDEX "AP"."AP_INVOICE_DISTRIBUTIONS_N2" PARALLEL 24;
The database is version 11.2.0.2 or above where Bug 8604502 has been fixed.
SOLUTION
The issue is discussed in
Bug 10408313 - INDEXES ARE CREATED WITH PARALLEL DEGREE 1 DURING IMPORT
closed with status 'Not a Bug'.
The import job with SQLFILE parameter option cannot use multiple execution streams.
It always executed with parallel 1. Hence its showing the PARALLEL 1 in generated sqlfile and this is an expected behavior.
When you run the import with parallel value and without sqlfile option, then you can see the actual index creation statement with correct parallel value in dw(worker) traces
REFERENCES
BUG:8604502 - INDEXES ARE ALWAYS CREATED WITH PARALLEL DEGREE 1 DURING IMPORT
BUG:10408313 - INDEXES ARE CREATED WITH PARALLEL DEGREE 1 DURING IMPORT
BUG:9710511 - DEGREE OF PARALLELISM IS NOT USED FOR CREATING INDEXES DURING IMPDP OF APPS DB
