SYS.V$DEADLOCKCYCLES

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

Usage with TimesTen Scaleout

This view contains data for the local element. If the element has a transaction that is part of the cycle, the element reports informations about its transactions.

Usage with TimesTen Classic

This view contains data for the database to which the application is connected. It has the same contents as SYS.GV$DEADLOCKCYCLES.

Related view

SYS.GV$DEADLOCKCYCLES

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