|
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
|