gtrid - cheeyoung/sqlplus-public GitHub Wiki
"....f9dfa43b.786.6.193159" from the Global Transaction Id in the entry at 0xc0000006f1949fc0
tightly coupled transaction with 1 branch
...
122310 (te.gtrid 0xc0000006f1949fc0) ....f9dfa43b.786.6.193159
122311 #branches = 1, type = 0x2, flg = 0x00
122312 branches = c0000006ec621ba8
122313 transactions = c00000070be40bb8
122314 branch#0 #refs = 1, #prep'd = 0, flags = 0x200, npi = N, ltidx = 255
122315 bt.bid: ...[786.6.193159][1.17]
122316 gti.fmt: 0004ac1e gti.tln: 28 gti.bln: 26
122317 gti.tid = ....f9dfa43b.786.6.193159
122318 gti.bid = ...[786.6.193159][1.17]
...
34.3.1 Determining the ID Number and Status of Prepared Transactions
Table 34-1 DBA_2PC_PENDING
Column | Description |
---|---|
LOCAL_TRAN_ID | |
GLOBAL_TRAN_ID | Global database identifier in the format global_db_name.db_hex_id.local_tran_id, where db_hex_id is an eight-character hexadecimal value used to uniquely identify the database. This common transaction ID is the same on every node for a distributed transaction. |
STATE | STATE can have the following values: |
Note: When the LOCAL_TRAN_ID and the GLOBAL_TRAN_ID for a connection are the same, the node is the global coordinator of the transaction.
DBA_2PC_PENDING describes distributed transactions awaiting recovery.
V$GLOBAL_TRANSACTION displays information on the currently active global transactions.
Column | Datatype | Description |
---|---|---|
STATE | VARCHAR2(38) | |
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) |