Re: PX Deq Credit: send blkd

Hi Christian,

thanks for the clarification!

Christian Antognini schrieb:
>> | 0 | CREATE TABLE STATEMENT | | 336M| 54G| 83600
>> | 1 | LOAD AS SELECT | KLM_TEST3 | | |
>> | 2 | PX COORDINATOR | | | |
>> | 3 | PX SEND QC (RANDOM) | :TQ10000 | 336M| 54G| 45403
>> | 4 | PX BLOCK ITERATOR | | 336M| 54G| 45403
>> | 5 | TABLE ACCESS FULL | KLM_TEST | 336M| 54G| 45403

> 
> This clearly shows that the query optimizer decided to not parallelize
> the DML part of the statement.

Now the magic question: How can I change that?

Thanks
Martin

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l