Database Utilities (MOSC)

MOSC Banner

Data Import using IMPDP is deadly slow.

edited Jan 6, 2010 7:36AM in Database Utilities (MOSC) 3 commentsAnswered
 Hi

I am trying to import data using impdp utility, Presently it is trying to create a domain index from more than 8 Hrs and status it is still showing as executing.

Is there any way I can diagnose wheter it is hang or it is still doing something.

Import> STATUS

Job: SYS_IMPORT_SCHEMA_01
  Operation: IMPORT
  Mode: SCHEMA
  State: EXECUTING
  Bytes Processed: 61,879,358,544
  Percent Done: 99
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /data/impdp_osxx/OSXX_1.dmp
  Dump File: /data/impdp_osxx/OSXX_2.dmp
  Dump File: /data/impdp_osxx/OSXX_3.dmp

Worker 1 Status:
  State: EXECUTING
  Object Schema: OSXX
  Object Name: A44_IX1

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