Row Cache Deadlock on DC_USERS (Doc ID 1352252.1)

Last updated on APRIL 29, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Checked for relevance on 23-April-2015

Symptoms

  • Alert.log shows the following message:
     
  • Instance may crash
  • An internal deadlock occurs but it is not trapped and No ORA-00060 error is raised
  • An alter user is being performed at the same time as a grant
  • The process granting the resource contains ktatminextsz. in the stack
  • Trace file shows that the Row cache enqueue contended on is DC_USERS
  • Waiting session looks like this:

    Cause

    Sign In with your My Oracle Support account

    Don't have a My Oracle Support account? Click to get started

    My Oracle Support provides customers with access to over a
    Million Knowledge Articles and hundreds of Community platforms