Database Utilities (MOSC)

MOSC Banner

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

*** 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

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