Database Administration (MOSC)

MOSC Banner

full expdp ran very slow for a small 3G database

edited Mar 31, 2018 5:02AM in Database Administration (MOSC) 2 commentsAnswered

My expdp (data pump) full export job that took 4 hours to complete only took 30 minutes if I used the conventional export.

Data seemed dumped out very fast but it was hanging for couple hours for "KSV master wait".

I've seen the following SQLs were using high CPU and ran very slowly.

BEGIN

  SYS.KUPW$WORKER.MAIN('FULL_EXP1', 'SYSTEM', 0);

  END;

 

From the information collected from OEM, the above sessions were all

blocked by "KSV master wait".

I suspect we were getting the following bug.

- Bug 21128593 - UPDATING THE MASTER TABLE AT THE END OF DP JOB IS SLOW STARTING WITH 12.1.0.2

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