Re: PX Deq Credit: send blkd

From: William Robertson <william_at_williamrobertson.net>
Date: Fri, 19 Sep 2008 13:34:14 +0100
Message-ID: <a3edf8ae0809190534k3c000ec2p51ec3869dc74ad00@mail.gmail.com>


From the docs (Data Warehousing Guide, 10.2):

"A DML statement can be parallelized only if you have explicitly enabled parallel DML in the session with the ENABLE PARALLEL DML clause of the ALTER SESSION statement."

Do you need to enable parallel DML?

2008/9/19 Martin Klier <usn_at_usn-it.de>

> I tried to
> CREATE TABLE2 TEST PARALLEL 32 AS SELECT * FROM TEST;
>
> It works, but the 32 parallel processes are only query processes, there
> is only ONE writing process. Due to that, all parallel query processes
> are waiting with "PX Deq Credit: send blkd"
>
> How can I make it parallel on WRITING side of the statement?
>
> The bahaviour is similar or same if I do an
> INSERT /*+ APPEND PARALLEL(TEST2,32) */ INTO TEST2 SELECT * FROM TEST;
> when both sides are identically partitioned (4 partitions).
>
> Any further clues? Or known no-gos?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 19 2008 - 07:34:14 CDT

Original text of this message