Unanswered: Create table as select /*+ parallel/ from
Following is a create table statement :
CREATE TABLE TEMP
PARALLEL 64 NOLOGGING
PARTITION BY HASH (EMP_ID)
PARTITIONS 64 STORE IN (MRI_D)
SELECT /*+ PARALLEL (emp, 64) PARALLEL(detail,64) USE_HASH(emp,detail) */
emp.emp_id = detail.emp_id;
Now , We have 16 processors . And each processor has Degree of parallelism = 4 .
EMPLOYEE table contains 170 millions of data.
EMP_DETAILS table contains 70 millions of data .
I couldn't test this query with 16 processors . I did test the query in 4 processors.
My question is :
Does this query create 16 different thread because we have 16 processors and we are using PARALLEL hint . Because when we are going to create the table using this query , the query is getting hanged . we had to kill this process .
Does anyone have any idea regarding this ?
Or is there any material regarding this? I tried several material in the net , but didn't dind out appropriate one .