My Oracle Support Banner

How To Relate DataPump PARALLEL Parameter To Parallel Query Slaves (Doc ID 1288037.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

Very often, you may have a concern about the PARALLEL parameter in DataPump. Is DataPump actually working in Parallel mode and it's actually using the Degree of Parallelism that was requested. This document will attempt to demonstrate how you can see see the level of parallelism that DataPump is using on import.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 IMPORT STATEMENT
 SNAPSHOT STATUS DURING TABLE IMPORT PHASE
 SNAPSHOT OF STATUS DURING INDEX IMPORT PHASE
 How to relate the Datapump jobs to the Parallel Slaves
 Find the sid and serial# of the Datapump jobs
 Relate the sid and serial# to the Parallel query Coordinator and slaves.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.