Re: PX Deq Credit: send blkd

From: Martin Klier <usn_at_usn-it.de>
Date: Mon, 22 Sep 2008 10:34:16 +0200
Message-ID: <48D75888.4040100@usn-it.de>

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

Received on Mon Sep 22 2008 - 03:34:16 CDT