How to Avoid Intermittent Deadlocks During High Load AQ Enqueue ? (Doc ID 1929908.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

Allows to database administrators and to Avoid Intermittent Deadlocks During High Load AQ Enqueue or the occurrance of ORA 600 [KTCWIT1_XID0].

As in certain cases, under high load, and mostly the deadlocks involve two resources.

Specially when running RAC but with application affinity against RAC nodes, so the enqueue and dequeue against specific queues never occurs cross instance.

In certain applications, transaction is a global transaction coming from a Transaction Processing Monitor (TPM), such as Tuxedo.

In few cases, the deadlocks are Single resource deadlocks.

Solution

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