7.228 V$FLASHBACK_TXN_MODS

V$FLASHBACK_TXN_MODS displays the individual modifications of all the transactions in memory.

This view is relevant AFTER a compensating transaction has been started through the DBMS_FLASHBACK.TRANSACTION_BACKOUT() set of functions, and is no longer relevant once the compensating transaction is either committed or rolled back. It also provides a tabular representation of the undo SQL that is not available through the CLOB XML construct in the DBA_FLASHBACK_TXN_REPORT view.

Column Datatype Description

COMPENSATING_XID

RAW(8)

Transaction ID of the compensating transaction

COMPENSATING_TXN_NAME

VARCHAR2(255)

Name of the compensating transaction

XID

RAW(8)

Transaction ID of a relevant transaction found in memory

TXN_NAME

VARCHAR2(255)

Name of the transaction with XID as the transaction ID; NULL if none

PARENT_XID

RAW(8)

Parent transaction ID (for a PDML transaction)

INTERESTING

NUMBER

If the transaction is in the transaction dependency graph

ORIGINAL

NUMBER

If the transaction is part of the input set provided

BACKOUT_SEQ

NUMBER

Order in which the transaction has been backed out

UNDO_SQL

VARCHAR2(4000)

Undo SQL for the modification

UNDO_SQL_SQN

NUMBER

Order in which the given SQL has been executed to back out this transaction

UNDO_SQL_SUB_SQN

NUMBER

If the undo SQL is greater than 4000 bytes, then a sequence number, starting from 1, of a 4000-byte division of the undo SQL

BACKOUT_SQL_ID

NUMBER

SQL ID of the undo SQL (used only for this compensating transaction)

OPERATION

VARCHAR2(128)

Operation (such as insert/update/delete) performed by the forward-going operation

BACKEDOUT

NUMBER

Indicates whether the transaction has been backed out as of now

CONFLICT_MOD

NUMBER

If the concerned modification is causing a conflict

MODS_PER_LCR

NUMBER

Sometimes an LCR could cause multiple modifications (for example, an update of an IOT could actually be a delete followed by an insert)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also: