V$OB_TRANSACTION_PARTICIPANTS

2025-12-09 07:09:36  Updated

Feature

This view displays the context information about the transaction participants on the current OBServer node.

Fields

Field Type Nullable Description
TENANT_ID NUMBER(38) NO The ID of the tenant.
SVR_IP VARCHAR2(46) NO The IP address of the OBServer.
SVR_PORT NUMBER(38) NO The port number of the OBServer.
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.

Contact Us