Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

EXPDP taking really long to export a table.

User_LELD2Jan 5 2023

Hello,

I have recently set up a script to make a full export over night of my Production database.
For couple of weeks now i have noticed that it is really slow on one specific table and the rest of tables are fine and really quick. Export take about 6-7-8h and is around 600GB in total and that one table takes 3-4-5h of the export time.
I am Running Oracle 19c (19.16) in RAC (2 nodes) on AIX 7.2

This is my export script:
expdp system/****** parfile=/backup/expdp.par
directory=dp_backup
exclude=statistics
dumpfile=prod.dmp
logfile=prod_exp.log
full=Y
METRICS=YES
LOGTIME=ALL

This is a part of the export log where the problematic table "NLBTB"."IFRS9_CALC_TEMP" is.
As you can see the rest of the tables which some are bigger, execute just fine and quickly.

Would appreciate any help.