Re: PX Deq Credit: send blkd

Hi Ian,

Ian Cary schrieb:
> Another suggestion might be to try this
>
> create table klm_test3 as select * from klm_test where 1=2;
>
> insert /*+ append parallel(t2 16) */ into klm_test3 t2
> select /*+ parallel(t1 16) */ * from klm_test t1;
>
> This seems to work for me whereas the parallel create table only seems to
> parallelize the select (as you are observing)

I retried the suggestion word by word - here I can see one CPU-consuming process as well, and 32 waiting with send blkd. I repeat, 32. It seems, that the parallelization on DDL/DML side just forces more data producers.

Strange thing, but this one becomes rather nasty since the project schedule tightens around my neck.

Anyway, Ian, Chris, guys - you are great ;)

Regards
Martin

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

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