Database Administration (MOSC)

MOSC Banner

impdp did not run parallel

edited Nov 6, 2023 8:26AM in Database Administration (MOSC) 3 commentsAnswered

Hi friends,

on linux 8 and oracle 19c database

I run expdp dumpfile=xxx%u parallel=20 .....

and it did run ok with 20 files

I then test impdp dumpfile=xxx%u parallel=20

and I checked if 20 processes in the database and there is only 2.

SQL> select sid, serial#, program, module from v$session where module like 'Data%';

    SID  SERIAL# PROGRAM

---------- ---------- ------------------------------------------------

MODULE                             

----------------------------------------------------------------

    797   20157 oracle@xxx (DM00)

Data Pump Master                       


   1168   27875 oracle@xxx (DW00)

Data Pump Worker                         


Please advise what is going on?

Thanks and appreciated !

Friendly

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center