Hi Experts, Please help advice... how to improve and speed up the import further.
impdp status : at 30 % from almost 2 days ::
=================================
Operation: IMPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 563,545,353,768
Percent Done: 30
Current Parallelism: 6
Job Error Count: 0
Job heartbeat: 8
*************************************************************************
impdp - Parfile:
DIRECTORY=EXPDP
logfile=imp_users.log
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
EXCLUDE=STATISTICS
LOGTIME=ALL
dumpfile=schema1_exp_01.dmp,
schema1_exp_02.dmp,
schema1_exp_03.dmp,
schema1_exp_04.dmp,
schema1_exp_05.dmp,
schema1_exp_06.dmp,
schema1_exp_07.dmp,
schema1_exp_08.dmp,
schema1_exp_09.dmp,
schema1_exp_10.dmp
schemas=schema1,
schema2,
......
......
schema16
ENCRYPTION_PASSWORD=HjtF$y~gr_s6b&dA
parallel=6
cluster=N
*************************************************************************
Environment :
===========
DB : Oracle 19c, Non-CDB
Expdp dumpsize - 577 GB
OS - AWS Ec2 linux
CPU - 4
RAM - 30 GB,
SGA - 15gb , swap - 15gb
sga_max_size big integer 15168M
sga_min_size big integer 0
sga_target big integer 15168M
unified_audit_sga_queue_size integer 1048576
pga_aggregate_limit big integer 12000M
pga_aggregate_target big integer 6000M
NOTE: Tried with pre-12c -- ALTER SYSTEM SET pga_aggregate_limit=0 SCOPE=BOTH;
The following DB options/parameters were set:
====================================
FORCE LOGGING is disabled:
SQL> alter database no force logging;
FLASHBACK is disabled:
SQL> alter database flashback off;
ARCHIVELOG modes is disabled: SQL> alter database noarchivelog;
Disable BLOCK CORRUPTION checking mechanism:
SQL> alter system set DB_BLOCK_CHECKING=FALSE;
SQL> alter system set DB_BLOCK_CHECKSUM=OFF;
Disable DLM Statistics Collection:
SQL> alter system set “_dlm_stats_collect”=0 SCOPE=SPFILE;
NOTE: Source tbs are conventional smallfile, but in target all are bigfile tbs where import is in progress (not sure if this will have any impact on import).
Import current status :
