Database Administration (MOSC)

MOSC Banner

(Oracle 12c) IMPDP Optimize speed & time

edited Dec 29, 2015 3:08AM in Database Administration (MOSC) 19 commentsAnswered ✓

Hello,

I have Oracle 12 c (Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit) on Windows Server 2012 R2 Standard

32 GB RAM

2.66GHz (2 processors)

Oracle server contains one database with about 200 schemas.

I wonder how can i improve data pump import (impdp) speed/time. because sometimes it take about 2 hours during drop and import one schema.

memory parameters are setting like below

SQL> show parameter target;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

archive_lag_target                   integer     0

db_big_table_cache_percent_target    string      0

db_flashback_retention_target        integer     1440

fast_start_io_target                 integer    0

fast_start_mttr_target               integer     0

memory_max_target                    big integer

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