Any way to tuning database export/import to be faster ?
Dear Friends,
Does anyone have experience tuning exports to be faster?
- Some parameters have been applied:
- parameter SHARED_POOL_SIZE —> base on SGA
parameter DISK_ASYNCH_IO ———> true
parameter DB_BLOCK_CHECKING ——————> false
parameter DB_BLOCK_CHECKSUM —————> no
- parameter SHARED_POOL_SIZE —> base on SGA
*** As the database size is around 3TB, the export took 4 hours.
+ Below is the PAR file:
PARALLEL=46
schemas=XNAME
DUMPFILE=XFILE_NAME_dump%L.dmp
FILESIZE=100GB
METRICS=Y
LOGTIME=ALL
logfile=.XLOG_NAME_dump%L.log
JOB_NAME=XJOB_Name_dump
DIRECTORY=XDIR
EXCLUDE=STATISTICS
COMPRESSION=ALL
COMPRESSION_ALGORITHM=MEDIUM
FLASHBACK_TIME=SYSTIMESTAMP