I have an Oracle 21 server where the import and export commands are very slow (especially the import commands). When you run impdp, the version, copyright and connecting to: Oracle Database 21c messages appear... from here several minutes may pass (between 10 and 20 min), and it begins to mount as normal. There are many daily connections on that server, but everything is fine, the only slow thing is impdp and expdp (imp and exp are fine).
These are some commands that I usually use:
impdp system/*****@ORCL DIRECTORY=DIR_DATAPUMP DUMPFILE=file.dmp LOGFILE=file.log REMAP_SCHEMA=SCHEMA1:SCHEMA2 REMAP_TABLESPACE=TABLESPACE1:TABLESPACE2 FULL=Y
impdp system/*****@ORCL DIRECTORY=DIR_DATAPUMP DUMPFILE=file.DMP LOGFILE=file.LOG SQLFILE=file.SQL
expdp system/*****@ORCL schemas=XXX directory=DIR_DATAPUMP dumpfile=file.dmp logfile=file.log
Thanks
PS: sorry for my English, it's Google Translate