Re: PX Deq Credit: send blkd

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Mon, 22 Sep 2008 10:32:26 +0100
Message-ID: <OFF81D6BDD.280E8512-ON802574CC.0033E554-802574CC.0034689D@ons.gsi.gov.uk>


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_at_usn-it.de |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 22/09/2008 09:34 |
| | Please respond to |
| | usn |
| | |
|---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: usn_at_usn-it.de | | cc: Christian.Antognini_at_trivadis.com, oracle-l_at_freelists.org | | 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

--
http://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.
i0zX+n{+i^
Received on Mon Sep 22 2008 - 04:32:26 CDT

Original text of this message