Note
This view is available starting with V4.0.0.
Purpose
The V$OB_TRANSACTION_PARTICIPANTS view displays the context information of transaction participants on the current OBServer node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| SESSION_ID | NUMBER(38) | NO | For V4.3.x versions:
|
| SCHEDULER_ADDR | VARCHAR2(64) | NO | The IP address of the node where the scheduler is located. |
| TX_TYPE | VARCHAR2(11) | NO | The transaction type. |
| TX_ID | NUMBER(38) | NO | The transaction ID. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream to which the transaction belongs. |
| PARTICIPANTS | VARCHAR2(1024) | NO | The list of participants. |
| CTX_CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The time when the context was created. |
| TX_EXPIRED_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The time when the transaction expired. |
| STATE | VARCHAR2(9) | NO | The context submission status. |
| ACTION | VARCHAR2(10) | NO | The last executed action. |
| PENDING_LOG_SIZE | NUMBER(38) | NO | The size of data to be persisted. |
| FLUSHED_LOG_SIZE | NUMBER(38) | NO | The size of data that has been persisted. |
| IS_EXITING | VARCHAR2(3) | NO | Indicates whether the context is exiting. |
| ROLE | VARCHAR2(8) | NO | The context role. |
| COORD | NUMBER(38) | NO | The ID of the corresponding coordinator (effective only after the transaction enters the commit phase). |
| LAST_REQUEST_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the last external request was received. |
| FORMATID | NUMBER(38) | NO | The xid format type. |
| GLOBALID | VARCHAR2(256) | NO | The global identifier of the XA transaction. |
| BRANCHID | VARCHAR2(256) | NO | The branch qualifier of the XA transaction. |
Sample query
Query the context information of transaction participants on the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$OB_TRANSACTION_PARTICIPANTS WHERE ROWNUM =1\G