Re: PX Deq Credit: send blkd

By enabling parallel DDL perhaps? Apologies if I missed the post where you confirmed that was already enabled.

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

> 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?
>
>
>
>

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