Database Utilities (MOSC)

MOSC Banner

Why EXPDP suddenly takes too long than usual? How to resolve this?

edited Apr 18, 2025 11:48PM in Database Utilities (MOSC) 8 commentsAnswered

Oracle Database 11g
We have a expdp scheduled daily at 12am, the usual backup takes approximately 1 hour to complete. But suddenly it takes longer than usual approximately more than 10 hours. Below is the sample expdp line.

expdp system/********* directory=DATA_PUMP_DIR_BO dumpfile=FileName.'date +%Y%m%d'_%U.dmp schemas=SCHEMA1, SCHEMA2, SCHEMA3 logfile=$ORACLE.SID.FILENAME.'date +%Y%m%d'.expdp.log parallel=2;

Since it takes too long we decided to kill the job with below commands

1. attach to the job.
expdp system/********* attach=SYS_EXPORT_SCHEMA_40

2. Kill the job

kill_job

3. typed YES to confirm.

after confirmation, below error prompts

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