Database DataWarehousing (MOSC)

MOSC Banner

two PQ coordinators

edited Mar 31, 2014 12:00PM in Database DataWarehousing (MOSC) 3 commentsAnswered

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 !

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center