Database Utilities (MOSC)

MOSC Banner

Oracle 11.2.0.4 impdp every slow on step "Object Type: SCHEMA_EXPORT/VIEW/COMMENT"

edited Oct 25, 2016 5:00AM in Database Utilities (MOSC) 7 commentsAnswered

Hi,

I am import data into 11.2.0.4 RAC database using impdp. dump file size is around 13GB. Tables loading and index rebuild are fast.

But it is very slow on step "Processing object type SCHEMA_EXPORT/VIEW/COMMENT"

Import> status

Job: SYS_IMPORT_FULL_01

  Operation: IMPORT

  Mode: FULL

  State: EXECUTING

  Bytes Processed: 13,628,484,152

  Percent Done: 99

  Current Parallelism: 3

  Job Error Count: 0

  Dump File: /u40/oracle/backup/dev1129/expdp_ifsprd2_01.dump

  Dump File: /u40/oracle/backup/dev1129/expdp_ifsprd2_02.dump

  Dump File: /u40/oracle/backup/dev1129/expdp_ifsprd2_03.dump

Worker 1 Status:

  Process Name: DW00

  State: EXECUTING

  Object Type: SCHEMA_EXPORT/VIEW/COMMENT

  Completed Objects: 29,280

Tagged:

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