SYS.V$DEADLOCKCYCLES

This view contains data about the transactions of the participants in the cycles.

Columns

Column name Type Description

DID

TT_INTEGER NOT NULL

Identifier for the cycle

CYCLEINDEX

TT_SMALLINT NOT NULL

Index in the dependency order cycle from the victim

REQUESTER_ID

TT_VARCHAR(16) INLINE NOT NULL

Transaction id of the cycle

REQUESTER_QUERYID

TT_VARCHAR(64) INLINE

Command cache id for the requester's query

HOLDER_XID

TT_VARCHAR(16) INLINE

Transaction id of the holder

RESOURCE

TT_VARCHAR(128) INLINE

Description of the resource

REQUESTER_STACK_DUMP

TT_VARCHAR(1024) NOT INLINE

Stack dump of the requester

HELDMODE

TT_VARCHAR(32) INLINE

Held mode of the lock

HOLDER_ELEMENTID

TT_SMALLINT

Id of the element on which the transaction is blocked

PRIORITY

TT_SMALLINT

Priority of the holding transaction