Re: PX Deq Credit: send blkd
- From: Martin Klier <usn@xxxxxxxxx>
- To: usn@xxxxxxxxx
- Date: Mon, 22 Sep 2008 10:34:16 +0200
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
Other related posts:
