Sfrgttk

What makes black pepper strong or mild?

If Jon Snow became King of the Seven Kingdoms what would his regnal number be?

Can inflation occur in a positive-sum game currency system such as the Stack Exchange reputation system?

Is there a documented rationale why the House Ways and Means chairman can demand tax info?

How can whole tone melodies sound more interesting?

IndentationError when pasting code in Python 3 interpreter mode

What does “buco del culo” mean here?

How to motivate offshore teams and trust them to deliver?

Precipitating silver(I) salts from the solution of barium(II) cyanate and iodide

How can I fade player when goes inside or outside of the area?

What does the "x" in "x86" represent?

Bonus calculation: Am I making a mountain out of a molehill?

Should I use Javascript Classes or Apex Classes in Lightning Web Components?

Does the Giant Rocktopus have a Swim Speed?

Why is black pepper both grey and black?

How much radiation do nuclear physics experiments expose researchers to nowadays?

Why don't the Weasley twins use magic outside of school if the Trace can only find the location of spells cast?

How do I keep my slimes from escaping their pens?

Why are there no cargo aircraft with "flying wing" design?

Does surprise arrest existing movement?

When -s is used with third person singular. What's its use in this context?

Should I call the interviewer directly, if HR aren't responding?

How to bypass password on Windows XP account?

Do you forfeit tax refunds/credits if you aren't required to and don't file by April 15?

Oracle data pump import parallel configuration

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

1

I am trying to track down a cause for a difference in oracle impdp processing, and I am not finding anything, so I am wondering if anyone here can explain the cause of the differences.

At times I have seen times where using the parallel=x parameter in oracle datapump will cause either multiple tables to be inserted at once, up to the value of 'x', or other times will use parallel threads to import a single table.

I have not been able to track down what might be causing the difference in performance, and I am wondering if anyone has an explanation, or even just a direction to point me to. It would be helpful to determine why it runs in a given matter.

For instance right now I am monitoring a single table, data_only import that was started with parallel=8 in the command, but the import job is only using a single thread to do the import, as shown by the following hint the insert query /+ PARALLEL("XXXXX",1)+/. If the process would use the maximum 8 threads specified to should run much faster.

oracle oracle-11g-r2 import parallelism impdp

share|improve this question

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

bumped to the homepage by Community♦ 1 min ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

1

I am trying to track down a cause for a difference in oracle impdp processing, and I am not finding anything, so I am wondering if anyone here can explain the cause of the differences.

At times I have seen times where using the parallel=x parameter in oracle datapump will cause either multiple tables to be inserted at once, up to the value of 'x', or other times will use parallel threads to import a single table.

I have not been able to track down what might be causing the difference in performance, and I am wondering if anyone has an explanation, or even just a direction to point me to. It would be helpful to determine why it runs in a given matter.

For instance right now I am monitoring a single table, data_only import that was started with parallel=8 in the command, but the import job is only using a single thread to do the import, as shown by the following hint the insert query /+ PARALLEL("XXXXX",1)+/. If the process would use the maximum 8 threads specified to should run much faster.

oracle oracle-11g-r2 import parallelism impdp

share|improve this question

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

bumped to the homepage by Community♦ 1 min ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I am trying to track down a cause for a difference in oracle impdp processing, and I am not finding anything, so I am wondering if anyone here can explain the cause of the differences.

At times I have seen times where using the parallel=x parameter in oracle datapump will cause either multiple tables to be inserted at once, up to the value of 'x', or other times will use parallel threads to import a single table.

I have not been able to track down what might be causing the difference in performance, and I am wondering if anyone has an explanation, or even just a direction to point me to. It would be helpful to determine why it runs in a given matter.

For instance right now I am monitoring a single table, data_only import that was started with parallel=8 in the command, but the import job is only using a single thread to do the import, as shown by the following hint the insert query /+ PARALLEL("XXXXX",1)+/. If the process would use the maximum 8 threads specified to should run much faster.

oracle oracle-11g-r2 import parallelism impdp

share|improve this question

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

share|improve this question

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

share|improve this question

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

asked Aug 10 '17 at 17:36

PatrickPatrick

199214

1 Answer
1

active

oldest

votes

0

Two common reasons:

1. Each worker thread uses a seperate dumpfile and requires exclusive access to it. If you have fewer dumpfiles than the degree of parallelism you provided, the parallel threads will not be fully utilized. If you have a single dump file, only 1 worker thread can be active.




2. Tables that contain Basicfile LOB columns are not be exported or imported in parallel. This is a known restriction and documented in: DataPump Export/Import Of LOBs Are Not Executed in Parallel (Doc ID 1467662.1)

Workarounds include:

• seperate partitions can be imported in parallel


• start multiple data pump jobs and distribute data between them using the QUERYparameter.

share|improve this answer

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Neither of those reasons seem to fit my situation. The table does not have any LOB columns. The dump that I am using as the source for this import is made up of 10 files. While its possible that the table was written just to a single file, based on the file sizes, that is doubtful.
  
  – Patrick
  Aug 10 '17 at 19:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  it is explainable if table is non partitioned and if you look in dba_tables, degree column will have a 1.
  
  – Raj
  Aug 11 '17 at 12:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Raj, I checked and most tables are set to one. Can this be changed?
  
  – Patrick
  Aug 14 '17 at 15:31
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f183203%2foracle-data-pump-import-parallel-configuration%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Two common reasons:

1. Each worker thread uses a seperate dumpfile and requires exclusive access to it. If you have fewer dumpfiles than the degree of parallelism you provided, the parallel threads will not be fully utilized. If you have a single dump file, only 1 worker thread can be active.




2. Tables that contain Basicfile LOB columns are not be exported or imported in parallel. This is a known restriction and documented in: DataPump Export/Import Of LOBs Are Not Executed in Parallel (Doc ID 1467662.1)

Workarounds include:

• seperate partitions can be imported in parallel


• start multiple data pump jobs and distribute data between them using the QUERYparameter.

share|improve this answer

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Neither of those reasons seem to fit my situation. The table does not have any LOB columns. The dump that I am using as the source for this import is made up of 10 files. While its possible that the table was written just to a single file, based on the file sizes, that is doubtful.
  
  – Patrick
  Aug 10 '17 at 19:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  it is explainable if table is non partitioned and if you look in dba_tables, degree column will have a 1.
  
  – Raj
  Aug 11 '17 at 12:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Raj, I checked and most tables are set to one. Can this be changed?
  
  – Patrick
  Aug 14 '17 at 15:31
  

  
  
  
  

add a comment | 

0

Two common reasons:

1. Each worker thread uses a seperate dumpfile and requires exclusive access to it. If you have fewer dumpfiles than the degree of parallelism you provided, the parallel threads will not be fully utilized. If you have a single dump file, only 1 worker thread can be active.




2. Tables that contain Basicfile LOB columns are not be exported or imported in parallel. This is a known restriction and documented in: DataPump Export/Import Of LOBs Are Not Executed in Parallel (Doc ID 1467662.1)

Workarounds include:

• seperate partitions can be imported in parallel


• start multiple data pump jobs and distribute data between them using the QUERYparameter.

share|improve this answer

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Neither of those reasons seem to fit my situation. The table does not have any LOB columns. The dump that I am using as the source for this import is made up of 10 files. While its possible that the table was written just to a single file, based on the file sizes, that is doubtful.
  
  – Patrick
  Aug 10 '17 at 19:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  it is explainable if table is non partitioned and if you look in dba_tables, degree column will have a 1.
  
  – Raj
  Aug 11 '17 at 12:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Raj, I checked and most tables are set to one. Can this be changed?
  
  – Patrick
  Aug 14 '17 at 15:31
  

  
  
  
  

add a comment | 

Two common reasons:

1. Each worker thread uses a seperate dumpfile and requires exclusive access to it. If you have fewer dumpfiles than the degree of parallelism you provided, the parallel threads will not be fully utilized. If you have a single dump file, only 1 worker thread can be active.




2. Tables that contain Basicfile LOB columns are not be exported or imported in parallel. This is a known restriction and documented in: DataPump Export/Import Of LOBs Are Not Executed in Parallel (Doc ID 1467662.1)

Workarounds include:

• seperate partitions can be imported in parallel


• start multiple data pump jobs and distribute data between them using the QUERYparameter.

share|improve this answer

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931

share|improve this answer

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931

answered Aug 10 '17 at 17:59

Balazs PappBalazs Papp

27.2k2931