7.254 V$GLOBAL_TRANSACTION

V$GLOBAL_TRANSACTION displays information on the currently active global transactions.

Column Datatype Description

FORMATID

NUMBER

Format identifier of the global transaction

GLOBALID

RAW(64)

Global transaction identifier of the global transaction

BRANCHID

RAW(64)

Branch qualifier of the global transaction

BRANCHES

NUMBER

Total number of branches in the global transaction

REFCOUNT

NUMBER

Number of siblings for the global transaction (must be the same as branches)

PREPARECOUNT

NUMBER

Number of branches of the global transaction that have prepared

STATE

VARCHAR2(38)

State of the branch of the global transaction:

  • ACTIVE

  • COLLECTING

  • FINALIZED

  • FAILED

  • RECOVERING

  • UNASSOCIATED

  • FORGOTTEN

  • READY FOR RECOVERY

  • NO-READONLY FAILED

  • SIBLING INFO WRITTEN

  • [ORACLE COORDINATED]ACTIVE

  • [ORACLE COORDINATED]COLLECTING

  • [ORACLE COORDINATED]FINALIZED

  • [ORACLE COORDINATED]FAILED

  • [ORACLE COORDINATED]RECOVERING

  • [ORACLE COORDINATED]UNASSOCIATED

  • [ORACLE COORDINATED]FORGOTTEN

  • [ORACLE COORDINATED]READY FOR RECOVERY

  • [ORACLE COORDINATED]NO-READONLY FAILED

  • [MULTINODE]ACTIVE

  • [MULTINODE]COLLECTING

  • [MULTINODE]FINALIZED

  • [MULTINODE]FAILED

  • [MULTINODE]RECOVERING

  • [MULTINODE]UNASSOCIATED

  • [MULTINODE]FORGOTTEN

  • [MULTINODE]READY FOR RECOVERY

  • [MULTINODE]NO-READONLY FAILED

  • [MULTINODE]SIBLING INFO WRITTEN

  • COMBINATION

FLAGS

NUMBER

The numeric representation of the state

COUPLING

VARCHAR2(15)

Indicates whether the branches are free (FREE), loosely coupled (LOOSELY COUPLED), or tightly coupled (TIGHTLY COUPLED)

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