Database Utilities (MOSC)

MOSC Banner

ORA-04020: deadlock detected while trying to lock object GET_MESSAGE_TYPE During IMPDP

edited Jan 4, 2019 5:15AM in Database Utilities (MOSC) 2 commentsAnswered ✓

Hi,

IMPDP is getting hanged when it reaches to processing packages stage,

IMPDP DIRECTORY=DATA_PUMP_DIR   DUMPFILE=ADPPRD_28.DMP LOGFILE=ADPPRD_28.LOG

Trace File

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

*** 2018-12-12 19:02:46.365

A deadlock among DDL and parse locks is detected.

This deadlock is usually due to user errors in

the design of an application or from issuing a set

of concurrent statements which can cause a deadlock.

This should not be reported to Oracle Support.

The following information may aid in finding

the errors which cause the deadlock:

ORA-04020: deadlock detected while trying to lock object HR_BASE.GET_MESSAGE_TYPE

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

  object   waiting  waiting       blocking blocking

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