Note
This view is introduced since OceanBase Database V3.2.4.
Purpose
The GV$OB_DTL_INTERM_RESULT_MONITOR view displays the monitoring information about the DTL intermediate result manager.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TRACE_ID | varchar(64) | NO | The trace ID of the statement. |
| OWNER | varchar(64) | NO | The user of the intermediate result. |
| START_TIME | timestamp(6) | NO | The time when the intermediate result was written. |
| EXPIRE_TIME | timestamp(6) | NO | The expiration time of the intermediate result. |
| HOLD_MEMORY | bigint(20) | NO | The size of occupied memory, in bytes. |
| DUMP_SIZE | bigint(20) | NO | The dump size, in bytes. |
| DUMP_COST | bigint(20) | NO | The dump time consumed. |
| DUMP_TIME | timestamp(6) | YES | The dump point in time. |
| DUMP_FD | bigint(20) | NO | The file descriptor (FD) of the dump file. |
| DUMP_DIR_ID | bigint(20) | NO | The ID of the directory where the dump file is located. |
| CHANNEL_ID | bigint(20) | NO | The channel ID of DTL. |
| QC_ID | bigint(20) | NO | The query coordinator (QC) ID of the sender. |
| DFO_ID | bigint(20) | NO | The data flow operator (DFO) ID of the sender. |
| SQC_ID | bigint(20) | NO | The sub-query coordinator (SQC) ID of the sender. |
| BATCH_ID | bigint(20) | NO | The ordinal number in a batch in a Parallel Execution (PX) batch rescan scenario. |
| MAX_HOLD_MEMORY | bigint(20) | NO | The maximum size of occupied memory, in bytes. |