Database Backup and Recovery (MOSC)

MOSC Banner

expdp takes more than ten times longer to run

edited Jan 13, 2016 9:50AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

Hello,

We are running Oracle Database 12.1.0.1.0 on Centos 6.6.

We are running this command to make the expdp:

expdp ops$querix/password  \

SCHEMAS=OPS$QUERIX\

LOGTIME=ALL METRICS=YES \

DIRECTORY=DUSA_DATA_PUMP_DIR \

FILESIZE=2GB REUSE_DUMPFILES=YES \

DUMPFILE=DU_EXP_SCHEMAS_%U \

LOGFILE=DU_EXP_SCHEMAS_PRUEBA.log \

JOB_NAME=DU_EXP_SCHEMAS_PRUEBA

The problem is that this command, from one day to another, is taking 36 hours, while it usually took 30 minutes.

What I did to try to solve the issue:

-We have statistics updated statistics with:

     EXEC dbms_stats.gather_database_stats;

-Also, I don't think there's an IO bottleneck, since while backing up, system load is low, and 'vmstat 1' shows no IO wait.

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