Purpose
The V$OB_TRANSACTION_PARTICIPANTS view displays the context information about the transaction participants on the current OBServer node.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| 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 | The session ID. |
| SCHEDULER_ADDR | VARCHAR2(64) | NO | The address of the node to which the scheduler belongs. |
| TX_TYPE | VARCHAR2(11) | NO | The type of the transaction. |
| TX_ID | NUMBER(38) | NO | The ID of the transaction. |
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| PARTICIPANTS | VARCHAR2(1024) | NO | The list of participants. |
| CTX_CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The point in time when the context was created. |
| TX_EXPIRED_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | YES | The point in time when the transaction times out. |
| 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 the data to persist. |
| FLUSHED_LOG_SIZE | NUMBER(38) | NO | The size of the persisted data. |
| IS_EXITING | VARCHAR2(3) | NO | Indicates whether a transaction participant is exiting. |
| ROLE | VARCHAR2(8) | NO | The role of the context. |