full expdp ran very slow for a small 3G database
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