SYS.V$DEADLOCKVICTIMS

This view contains data about deadlock victims.

Columns

Column name Type Description

DID

TT_INTEGER NOT NULL

Identifier for the cycle

VICTIM_XID

TT_CHAR(64) NOT NULL

Transaction id of the victim

TIME

TT_TIMESTAMP

Time the deadlock was detected on the element of the victim

VICTIM_ELEMENTID

TT_SMALLINT NOT NULL

Element id of the victim

EXECUTED

TT_TINYINT NOT NULL

1 if the deadlock was detected by the deadlock detector. Otherwise, 0.

ELEMENTID

TT_INTEGER NOT NULL

Ignore the elementId column. It is unused.