Re: PX Deq Credit: send blkd
- From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- To: usn@xxxxxxxxx
- Date: Mon, 22 Sep 2008 10:32:26 +0100
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.
Other related posts:
