two PQ coordinators
Hello,
We see the two PQ coordinators in our queries, why it is possible end how to understand it ?
What session do:
alter session enable parallel DML ;
set timing on
create table rwvl.orig20m as select * from rwvl.table_x2
where REP_DATE>=trunc(to_date('01-03-2013','DD-MM-YYYY')) and rownum <20000001
order by
CREDIT_FLAG,BALANCE_FLAG,GOODOK_FLAG,ST_BLOCK,CUST_CTG,TYPE,STATUS,
M_REG,REP_DATE,MSISDN_CLASS_ID,REGION,NOTACT_DAYS,NOPAY_DAYS,CUST_TYPE,CUST_CLASS;
The SQL Monitor screenshot is in attach.
Thanks !