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

Other related posts: