Database Administration (MOSC)

MOSC Banner

DB 12.1 Cross Platform datapump import for Transportable tablespace "STATISTICS/MARKER" takes 16 hrs

edited Apr 17, 2018 5:00AM in Database Administration (MOSC) 17 commentsAnswered

This is EBS 12.1.3 Oracle Database 12.1.0.2 of 7 TB size,  we are doing Cross Platform AIx - Linux DB Migration.

Datapump export is great and good.

While doing Datapump Import for Transportable tablespace, it takes good 16 hours on the following:

Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER

Importing statistics failed for 37 object(s);

     Completed 1 MARKER objects in 58032 seconds ?

What is this and why is this taking such a long time? How it can be fixed and make better performance ?

Script "auimpxtts.dat"  used here is

directory=dmpdir

metrics=y

dumpfile=xttsmeta%U.dmp

logfile=impxtts.log

exclude=TYPE

transport_datafiles=

'+DATA/ERP/DATAFILE/APPS_TS_ARCHIVE.328.972653191',

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