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) Cheers, Ian |---------+-----------------------------> | | usn@xxxxxxxxx | | | Sent by: | | | oracle-l-bounce@fr| | | eelists.org | | | | | | | | | 22/09/2008 09:34 | | | Please respond to | | | usn | | | | |---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: usn@xxxxxxxxx | | cc: Christian.Antognini@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx | | Subject: Re: PX Deq Credit: send blkd | >--------------------------------------------------------------------------------------------------------------| Hi, Martin Klier schrieb: > The plan is attached. Seems like the list strips even text file attachments. SQL> set lines 130 SQL> set pages 0 SQL> alter session force parallel ddl parallel 32; Session wurde gea"ndert. SQL> explain plan for create table KLM_TEST3 parallel 32 as select * from klm_test; EXPLAIN PLAN ausgefu"hrt. SQL> select * from table(DBMS_XPLAN.DISPLAY); Plan hash value: 2116879566 --------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | --------------------------------------------------------------------------------------------------------------------------------- | 0 | CREATE TABLE STATEMENT | | 336M| 54G| 83600 (2)| 00:19:31 | | | | | | | 1 | LOAD AS SELECT | KLM_TEST3 | | | | | | | | | | | 2 | PX COORDINATOR | | | | | | | | | | | | 3 | PX SEND QC (RANDOM) | :TQ10000 | 336M| 54G| 45403 (3)| 00:10:36 | | | Q1,00 | P->S | QC (RAND) | | 4 | PX BLOCK ITERATOR | | 336M| 54G| 45403 (3)| 00:10:36 | 1 | 4 | Q1,00 | PCWC | | | 5 | TABLE ACCESS FULL | KLM_TEST | 336M| 54G| 45403 (3)| 00:10:36 | 1 | 4 | Q1,00 | PCWP | | --------------------------------------------------------------------------------------------------------------------------------- 12 Zeilen ausgewa"hlt. SQL> -- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- //www.freelists.org/webpage/oracle-l This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk ********************************************************************************* Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications ********************************************************************************* Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics ********************************************************************************* The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.