RE: PX Deq Credit: send blkd

Sorry, typo, replace DML by DDL...

-----Original Message-----
From: Christian Antognini
Sent: Monday, September 22, 2008 11:56 AM To: 'Martin Klier'
Cc: oracle-l_at_freelists.org
Subject: RE: PX Deq Credit: send blkd

Hi Martin

> alter session force parallel ddl parallel 32;

This should not be necessary. The parallel DML are enabled by default... You can check that with the following query:

select pddl_status
from v$session
where sid = sys_context('userenv','sid')

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

HTH
Chris Antognini

Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch

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