Note
This view is introduced since OceanBase Database V4.2.0.
Purpose
The V$OB_PX_P2P_DATAHUB view displays information about data transmission operations that are executed in parallel.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node. |
| TRACE_ID | CHAR(64) | NO | The trace ID of the SQL statement involved in the data. |
| DATAHUB_ID | NUMBER | NO | The DataHub ID of the data. |
| MESSAGE_TYPE | VARCHAR2(256) | NO | The message type of the data. |
| TENANT_ID | NUMBER | NO | The ID of the tenant to which the data belongs. |
| HOLD_SIZE | NUMBER | NO | The size of the materialized data. |
| TIMEOUT_TS | TIMESTAMP(6) | NO | The expected timeout period of the data. |
| START_TIME | TIMESTAMP(6) | NO | The write start time. |